Count if based on criteria within cells on another sheet
 

I'm creating a summary sheet (sheet 2) and I'm looking for the correct
formula to calculate the number of cells populated in Sheet1!G5:G137 if cells
Sheet1!C5:C137 contain PO1A (or other criteris). Note: cells in column C are
text fields that may contain a number or a combination of numbers and letters.

If Sheet1!C5:C137 equals P01A, then count Sheet1!G5:G137

Thanks for any help I can get!

Count if based on criteria within cells on another sheet
 

Try this:

=SUMPRODUCT(--(Sheet1!C5:C137="PO1A"),--(Sheet1!G5:G137<""))

--
Biff
Microsoft Excel MVP


"--Viewpoint" wrote in message
...
I'm creating a summary sheet (sheet 2) and I'm looking for the correct
formula to calculate the number of cells populated in Sheet1!G5:G137 if
cells
Sheet1!C5:C137 contain PO1A (or other criteris). Note: cells in column C
are
text fields that may contain a number or a combination of numbers and
letters.

If Sheet1!C5:C137 equals P01A, then count Sheet1!G5:G137

Thanks for any help I can get!