“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hello! For example,I have some specified date in excel sheet1.And all dates in sheet2.I want if one date from sheet1 matches with dates in sheet2(full date range) ,then it should give the value above date in sheet2.
I have used this formula: =if(C5=Sheet2!J3:U3,Sheet2!J1,0)
I have got error called #VALUE!.
Please help me with this error.

Solved by E. C. in 19 mins

I have created a spreadsheet to track resource usuage and costs by hour over a number of months. I need a formula that sums the hours in a date range and multiplys by looking up an hourly rate from another sheet. This will be used to summarise monthly costs for a each person.

Solved by G. Q. in 25 mins

I need one cell to look at a specific range in a column, figure out if the date in those cells is between two dates and if it is I need it to take the value of the adjacent cells and sum them up. I have a column with dates, next to that a column with dollar amounts. I want one cell to make a sum of the amounts associated with a specific date range. Please help.

Solved by X. U. in 20 mins

I'm trying to write a formula that would find the percentage of Invoices that have stayed in the same Row rank for 2 months. The sheet I'm working on is labeled Top X and the formula should be written starting in Q200. The Row rank is found in column J, the Account ID is column B, and the Date range is in C.

Solved by G. J. in 22 mins

I'm trying to write a formula that would find the percentage of Customer Invoices that have stayed in the same Row rank (Column J) for 2 consistent months. The rankings are segmented based on the criteria in Column P.
The sheet I'm working on is labeled Top X and the formula should be inputted in Q200:AZ212. The Row rank is found in column J, the Account ID is column B, and the Date range is in C (note the date range is Text, but the corresponding Dates needed for segmenting the data are located in Q2:AZ2. Please let me know if you have any questions!

Solved by F. F. in 18 mins

I'm trying to write a formula that would find the percentage of Customer Invoices that have stayed in the same Row rank (Column J) for 2 consistent months. The rankings are segmented based on the criteria in Column P.
The sheet I'm working on is labeled Top X and the formula should be inputted in Q200:AZ212. The Row rank is found in column J, the Account ID is column B, and the Date range is in C (note the date range is Text, but the corresponding Dates needed for segmenting the data are located in Q2:AZ2. Please let me know if you have any questions!

Solved by Z. Y. in 14 mins

How can I count the number of rows within a certain date range from a different sheet in a workbook? Similarly, can I sum the numerical values in one column within that date range?

Solved by A. C. in 12 mins

Good Morning
I have data with multiple pivot tables. I have a slicer with date ranges, example 07-29-18 to 08-11-18, that brings the data together with this date range. When I choose this date range the data shows blank. When I choose Blank on my slicer the data shows up. I have removed the data and re-entered it. File is very large and has been working up to this date. If I go to the next date range I get the data

Solved by M. L. in 21 mins

I need a formula to calculate the number of values between 0-5 days and 6-10 days within specified date ranges

Solved by I. J. in 12 mins

I'm trying to create a formula that will give me the Sum of a row if the Form Source (Discoveries Set Data'!B:B) and Date Range (Discoveries Set Data'! D:AC) match the qualifications on associated columns on Sheet 1

Solved by Z. Y. in 16 mins