I am using sumproduct to count the number of times and entry appears between two dates.
The problem is that against each entry I am trying to find is the number I need to multiply bay:
e.g
=sumproduct(('Sheet1'!B2:B200>=A1)*('Sheet1'!B2:B200<=A2)*('Sheet1'!G2:G200="Injury"))
Cell A1 and A2 are two dates.
how do I multiple the each occasion of "Injury" by the number next to it in column F ?
This will give me the total number of injuries within my date range ?
Thanks
Bookmarks