View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
--Viewpoint --Viewpoint is offline
external usenet poster
 
Posts: 21
Default 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!