I'm using the following to count how many times a record meets a certain criteria.
=SUMPRODUCT((Data!$D$2:$D$65536>=Data!K14)*(Data!$D$2:$D$65536<=Data!L14)*(Data!$A$2:$A$65536="001"))
I'm look adding a, or "004". but i'm at a loss, any ideas? I my head this is how I would write it out.
=SUMPRODUCT((Data!$D$2:$D$65536>=Data!K14)*(Data!$D$2:$D$65536<=Data!L14)*(Data!$A$2:$A$65536="001" or "004"))
Bookmarks