Evening,
I am using this formula:
=SUMPRODUCT(($B$2:$B$16=G3)*($C$2:$C$16=$A$24))
to do the following thing:
- Count the number of times G3 is in column B
- but only if A24 is in column C
I now to change this so that is does
- Count the number of times G3 is in Column B
- but only if A24 or A25 ot F26 is in column C
Any ideas how I can adapt the end of the formula please?
Many thanks
Bookmarks