Thread
:
Count and Sum functions with 2 criterias
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Count and Sum functions with 2 criterias
Very true Pete, I also forgot to point out that I used Absolute ranges so
that the formula could be dragged down.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Pete_UK" wrote in message
...
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 -
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann