multi-if then formula i think

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

i have 3 columns of data. basically i want to query column A and B, for a
particular range, and if it meets that range/criteria, sum the totals in
column C.
for example, if A=HW and B=ST, then sum every $ in column C with that
criteria.
for column A, there are 4 different choices (hw, ss, ms, sa) and for column
B, there are 7 choices...so basically i want each unique choice to sum the
results.
tia
 
I think you mean

=SUMPRODUCT(--(A2:A200="hw"),--(B2:B200="choice 1"),C2:C200)

=SUMPRODUCT(--(A2:A200="ss"),--(B2:B200="choice 1"),C2:C200)



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
any way to put this in 1 formula? what you have below, i'd have to create 28
formulas...or make it to where i have 4 formulas (i'd define A)?
a=4 choices
b=7 choices
 
ok, nevermind on the below...was rethinking and that doesn't make sense.
bob - thanks for the answer, that's exactly what i need...but when i put it
in, i get a 0.00. might it be because in both col A and col B - i have
blanks.
 
Back
Top