Adding data in one column only if critera is met in another column

  • Thread starter Thread starter excelerator
  • Start date Start date
E

excelerator

I am using excel for analysis purposes and am trying to figure out ho
to compare two different columns of data. I would like to count th
number of responses in column "H" that equal "one" but only if the dat
in column "A" in that particular row is equal to "M". I don't know ho
else to explain this. If it doesn't make sense please let me know an
I'll draw up a more complete example. Thank you for you help
 
Try SUMPRODUCT in a cell in say, Sheet2:

=SUMPRODUCT((Sheet1!A1:A100="M")*(Sheet1!H1:H100=1))

Note that the ranges (A1:A100, H1:H100, etc) must be identical
and entire column references (A:A, H:H) cannot be used in SUMPRODUCT
 
=SUMPRODUCT((C2:C26="M")*(K2:K26="SA")) Got the answer from surfing th
forums, the search function is pretty useless. Thanks to Don Guillet
for originally answering a similar question
 
Back
Top