multi-if then formula i think
 

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

multi-if then formula i think
 

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)

"Ann" wrote in message
...
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

multi-if then formula i think
 

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

"Bob Phillips" wrote:

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)

"Ann" wrote in message
...
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

multi-if then formula i think
 

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.

"Ann" wrote:

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

"Bob Phillips" wrote:

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)

"Ann" wrote in message
...
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

multi-if then formula i think
 

nevermind again, i know where i made the mistake...thanks so much bob - that
did it!

"Ann" wrote:

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.

"Ann" wrote:

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

"Bob Phillips" wrote:

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)

"Ann" wrote in message
...
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