Count and Sum functions with 2 criterias
If you put your category range in two columns like this:
1 25
26 50
51 100
101 250
you could then simplify the formulae that Sandy gave you by refering
to the cells containing the range rather than include them explicitly
in the formulae.
Hope this helps.
Pete
On Oct 7, 10:44*am, Sue wrote:
Let me give an example, Say the Data looks like this:
Category * * * *Processed
2 * * * Yes
50 * * *No
40 * * *Yes
25 * * *Yes
90 * * *No
7102 * *Yes
198 * * Yes
648 * * No
The Format that I would like is as follows:
Category * * * * * *Processed (Yes) * * * * * * * * * * * * * * * Not
Processed(No)
* * * * * * * * * * * * Count * * * Sum(Amt) * * * * * * * * * * * Count * *
*Sum(Amt)
1 - 25 * * * * * * * * *2 * * * * * * * 27 * * * * * * * * * * * * * * * *0 *
* * * * * * *0
26 - 50 * * * * * * *
51 - 100
101 - 250
Total
I hope that helps..
--
Sue
"Bob Phillips" wrote:
Your question is not clear, at least to me.
I am not seeing where the variable data is and hat is repeated, so what
needs to be counted/summed?
--
__________________________________
HTH
Bob
"Sue" wrote in message
...
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- Hide quoted text -
- Show quoted text -
|