Looking to Count multiple items

[Randomhero180]

Hey All

I have a report that already counts multiple criteria, but I need it to count more and I cannot see where to add them to the formula I already have.

The formula I have counts items that meet a certain date criteria, a certain "status code" (ie complete), and what category it is in. I need it to count multiple status codes such as estimate, in progress, and complete.

here is the formula I have:

=SUMPRODUCT((TEXT(Sheet1!H19:H12678,"mmmyyyy")=TEXT('Current Images Available'!H1,"mmmyyyy"))*(Sheet1!B19:G12678=A3)*(Sheet1!V19:V12678=C2)*2.5)

A3 is the status code i am counting and I need to count multiple status codes.

I'm sorry it is difficult to explain, hope this makes sense.

Thanks in advance!

RH

 

[Domenic]

Try the following formulas, which need to be confirmed with CONTROL+SHIFT+ENTER...

=SUM(IF(TEXT(Sheet1!H19:H12678,"mmmyyyy")=TEXT('Current Images Available'!H1,"mmmyyyy"),IF(ISNUMBER(MATCH(Sheet1!B19:G12678,{"Estimate","In Progress","Complete"},0)),IF(Sheet1!V19:V12678=C2,1))))

or

=SUM(IF(TEXT(Sheet1!H19:H12678,"mmmyyyy")=TEXT('Current Images Available'!H1,"mmmyyyy"),IF(ISNUMBER(MATCH(Sheet1!B19:G12678,A3:A5,0)),IF(Sheet1!V19:V12678=C2,1))))

...where A3:A5 contains the text values...

Estimate
In Progress
Complete