COUNTIF combined with AND

[M. Cleaves]

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.

 

[just_jon]

Try --

=SUMPRODUCT(('PENDING SHIPMENTS'!$E$2:$E$145="100-1")*('PENDING SHIPMENTS'!$G$2:$G$145="RAW"))

 

[M. Cleaves]

Thank you very much...I had a feeling I was making use of the wrong function. Yours works great!