SUMIF Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Need some help please.

I have a spreadsheet that looks like the following:

Quarter % Prod A Prod B Prod C

Q4 75% 1 2 1
Q4 50% 2 1 1
etc, etc

I need to add up all those products in a cetain at a certain %

So far I can do do a SUMIF to get all those in PROD A in Q4 but I can't get
the % I need.

SUMIF (Range,Q4,Range)

need

SUMIF (Range,Q4 & 75%,Range)

Is it possible?

Thanks
 
Thanks Julie.

This seems to be the way forward. However I get an error #VALUE when putting
in the following:

=SUMPRODUCT((C1:C97="Q4")*(E1:E97="75%")*(G1:G97))

Where C1:C97 contains the quarter (Q4 etc), E1:E97 contains 75% and G1:G97
is the number of licences required to add up. Would the problem be related to
the % cell. As when highlighted it shows 75% but you actually enter .75?

Thanks

Steve
 
Back
Top