Hello All,
My first post here!!
I am having issues getting SUMIFS function to work where the matching criteria are Date and Time.
For example, Column A has bunch of dates (range name 'Date'), Column B has time (range name 'Time') and Column C has volume (range name 'Volume').
If I use =SUMIFS(Volume,A:A,I2,B:B,J2) (where I2 and J2 hold the date and time I want to match), it works.
But if I do =SUMIFS(Volume,Date,I2,Time,J2)
or even =SUMIFS(Volume,A2:A100,I2,B2:B100,J2)
I get 'Value' Error. Any suggestions what I am doing wrong?
I was thinking that it was a formatting issue but then even first formula shouldnt work. Note that 'Date' and 'Time' are dynamically named ranges (using offset function).
Note: This problem is only with SUMIFS. The other cousin i.e. SUMIF works fine with all.
Thanks,
Sumit
Bookmarks