SumIF, Countif,WhatIF
Posted by Jim on March 13, 2001 12:16 PM
Hi Excel Experts:
I am trying to compile a summary of only character data :
Example: Column A1 - A10 has an "E" or "N"
Column C a1 - A10 has either an "O" , V,or M.
How Do I count the number of O V or M in Column C based on if they are either a "E" or "N".
A1-A10 has 4 "E" and 6 "N"
C1-C10 has 2 "V" 4 "M" and 4 "O"
The Result would be a count of possibly
4 "E" of column a with 2"V" 1"M" and 1"O".
I am using a lot of visual basic and have protected the sheet so the user cannot change anything. I need a formula versus a Pivot Table.
Thank you for any assistance.
Jim
Posted by Mark W. on March 13, 2001 12:25 PM
...And, you don't want to use a PivotTable?
Posted by Mark W. on March 13, 2001 12:42 PM
...If so, then...
Assuming that cells E1:F1 contains {"E","N"} and
cells D2:D4 contains {"O";"V";"M"} then enter the
formula, {=SUM(($A$1:$A$10=E$1)*($B$1:$B$10=$D2))},
into cell E2, and copy right to cell F2 and copy
down to cell F4.
Posted by Mark W. on March 13, 2001 12:51 PM
...Make that...
{=SUM(($A$1:$A$10=E$1)*($C$1:$C$10=$D2))}
