Thread
:
Using nested IFs with CountIf
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
Posts: n/a
Using nested IFs with CountIf
Something like
=SUMPRODUCT(--(Sheet1!$C$2:$C$200="Com"),--(Sheet1!$A$2:$A$200=$A2),--(Sheet
1!$B$2:$B$200=B$1))
etc. assuming that A2 holds Milk, B1 holds Must etc.
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"Excel novice" <Excel
wrote in message
...
Can anyone help me I am trying to use the nested IF formula to add more
than
one criteria prior to counting the number of
instance a value appears in a table.
A B C
2 milk must Com
3 bread maybe Part
4 cheese never None
5 milk maybe Com
6 curry must Part
7 bread must None
So, I am trying to find the number of instances milk appears in the table,
which are "must" and "com". Then I am trying to count the number of
instances
milk appears with "maybe" and "com" etc. The result will produce an
anaylysis
of the entries for all the types in column A. The variances contained in
column A is small approx 6 types, so will enter the criteria into the
results
table like so:
The following table is for results which contain "Com"
Must Maybe Never
Milk 10 5 2
Bread 4 2 1
etc
The following table is for results which contain "Part"
Must Maybe Never
Milk 6 2 1
Bread 3 3 0
etc
I hope this is clear otherwise let me know, and thanks in anticipation.
Reply With Quote