=SUMPRODUCT(('PENDING SHIPMENTS'!$E$2:$E$145="100-1")*('PENDING SHIPMENTS'!$G$2:$G$145="RAW"))
This is a discussion on COUNTIF combined with AND within the Excel Questions forums, part of the Question Forums category; I'm wondering if it is possible to combine the COUNTIF formula with and AND. For example, in two columns of ...
I'm wondering if it is possible to combine the COUNTIF formula with and AND.
For example, in two columns of data the first column contains one of 8 possible entries. Column two contains one of 4 possible entries (both regulated by a validation list).
I am trying to count the number of times one entry occurs in the first column in conjunction with an entry in the second column, for a total of 32 possible combinations.
The result need only be the number of occurences (as I will be further manipulating the data).
Following is an non-working example of the present formula:
=COUNTIF(AND('PENDING SHIPMENTS'!E2:E145,"100-1",'PENDING SHIPMENTS'!G2:G145,"RAW"))
Thank you in advance.
Thank you very much...I had a feeling I was making use of the wrong function. Yours works great!