Hi, all
I have this one Excel file with data based on dates and time. I want to sum up the cost for a certain period (daily basis). Tried to use:
SUMPRODUCT(--(A$3:$A$581>=J11),--($A$3:$A$581<=K11),$E$3:$E$581)
But when I manually sum up the cost, it gives different answer.
Any part that is wrong in my formula? I have attached a test workbook for better understanding.
Looking forward to any feedback. Have a nice day!
Bookmarks