View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sue Sue is offline
external usenet poster
 
Posts: 285
Default Count and Sum functions with 2 criterias

Question:
Category Processed (Yes) Not Processed(No)
Count Sum(Amt) Count Sum(Amt)
1 - 25
26 - 50
51 - 100
101 - 250
Total

Data has two columns which are Amount and Status(Yes/No). Can someone help
me with the formulae to count the number of coumns which fall in each
Category and also sum of the amounts in those categories?
--
Sue