| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count text cells based on two criteria | Excel Worksheet Functions | |||
| Using a function to count cells based on multiple criteria | Excel Worksheet Functions | |||
| count cells,containing text, based on more than one criteria? | Excel Worksheet Functions | |||
| Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
| Count or Sum based on more than 1 criteria | Excel Worksheet Functions | |||
Linear Mode
