Hello
I need to sum the values in a range where that range is from april - august.
The months are numbered: jan=1, feb=2, march=3 etc.
I had a formula along the lines of:
=SUMPRODUCT((B5:B8503=2011)*(C5:C8503=4:8)*(H5:H8503))
This did not work.
Note the ideal "4:8" for months april - august. The intention being where column c contains numbers 4,5,6,7 and 8 then treat as true.
Is there a way to do this simply and elegantly - sumproduct for where a range of conditions are true?
I need to sum the values in a range where that range is from april - august.
The months are numbered: jan=1, feb=2, march=3 etc.
I had a formula along the lines of:
=SUMPRODUCT((B5:B8503=2011)*(C5:C8503=4:8)*(H5:H8503))
This did not work.
Note the ideal "4:8" for months april - august. The intention being where column c contains numbers 4,5,6,7 and 8 then treat as true.
Is there a way to do this simply and elegantly - sumproduct for where a range of conditions are true?