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