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.
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 ☺