SUMIF - with 2 identifiers.

  • Thread starter Thread starter Vachss14
  • Start date Start date
V

Vachss14

Hi All,

Sorry that my first post is a question.

I have 3 rows of data, 2 are identifiers and the 3rd is a figure I want
to sum, with sumif it can only use one column to identify what to sum
in the 3rd column, how can I get it so the formula works something
like:- SUMIF (Column A:B,column A = XXXX & Column B=XXXX, Column C:C)

I'll try to to explain better with an example:

Example:

Column A...Column B...Column C
1000..........Toad...........5
1000..........Toad...........5
1000..........Frog........... 6
1001..........Toad............5

How can I get it to sum column C if the identifiers are say 1000 & Toad
???

thanks

Vachss.
 
Vachss

Try using SUMPRODUCT(). In your example it would be:
=SUMPRODUCT((A2:A5=1000)*(B2:B5="Toad")*(C2:C5))

Andy.
 
Thanx for that idea, unfortunealty it quite do exactly what I hoped,
eventually got round the problem by suming the figures in column A &
to make a unique identifier and then I can sumif off that.....not idea
but OK as a temporary work around
 
It returns a #Num error - I think its to do with the formating of an
output from Peoplesoft which I import into XL for the report. I'm stil
working on it and it'll work eventually
 
Back
Top