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
|