Forum Discussion
Solved
SUM totals using VLOOKUP?
Hi All I have a table with dates in col A and a value in Col B in Sheet:Dates Lets say Col A is July 1st to July 31 and to make things easy the Value in Col B is the day So in sequence it would be...
You may try this one:
:Caveat: For better understanding & visualization I've taken smaller data set you need to extend as required.
Formula in cell U2:
=SUMPRODUCT(($W$2:$W$21>=$S2)*($W$2:$W$21<=$T2)*($X$2:$X$21))N.B. Adjust cell references in the formula as needed.
Try this:
=SUMIFS(Dates[Column2],Dates[Column1],CONCAT(">=",A1),Dates[Column1],CONCAT("<=",B1))
Where your Dates worksheet table is named Dates;
Sheet Dates has dates in column A and values in column B
Sheet Summary has start date in column A and end date in column B.
I placed the formula in cell D1 on the Summary sheet. Copy the formula down to the other 2 lines.
Hi
Thank you for your solution. However I used the one Rajesh_Sinha suggested and it works perfectly.
Thank you for your time in providing a solution.
Thank you for your solution. However I used the one Rajesh_Sinha suggested and it works perfectly.
Thank you for your time in providing a solution.
- Glad to help you,, keep asking ☺