Sumif using several columns

[uk747]

trying to add columns using a sumif

The names I'm using are in columns A, H and and J and the figures in B, F and K

Tried the formula belw but wouldnt work, said too many arguments

(A1:A30,E1:E30,H1:H30,J1:J30,"Dog",B1:B30,F1:F30,I1:I30,K1:K30) and tried named ranges =SUMIF(animal,"dog",age) and get value #

 

[FormR]

I think you would get a better response if you could show an example of your data and the expected results.

 

[s hal]

SUMIF() only accepts ONE codition and ONE range to check and ONE range to sum - you fed it too many conditions, which is why you got an error.

SUMIFS() is maybe what you want to use (if you are in 2007 or later version). Or the more advanced, SUM(IF()) if you are not.

I can't answer why your named range method didn't work, but I'd speculate for the same reason the first SUMIF() example did not.

 

[uk747]

I think you would get a better response if you could show an example of your data and the expected results.

Table below is in 3 different columns and it needs to add up the age every time dog appears

ANIMAL	Age
dog	5
cat	3
rabbit	2
dog	4
canary	3
parrot	2
snake	1

<tbody>
</tbody>

 

[uk747]

ADVERTISEMENT

unfortunately only have 2003, but out of curiosity how would the formula appear in 2007 using sumifs

 

[s hal]

You just need to have 3 SUMIF() functions: SUMIF()+SUMIF()+SUMIF(). There's probably a more complicated way to do this as well, but I'd stick with the basics...

 

[FormR]

One option:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	ANIMAL	Age		ANIMAL	Age		ANIMAL	Age		Sum
2	dog	5		dog	5		dog	5		27
3	cat	3		cat	3		cat	3
4	rabbit	2		rabbit	2		rabbit	2
5	dog	4		dog	4		dog	4
6	canary	3		canary	3		canary	3
7	parrot	2		parrot	2		parrot	2
8	snake	1		snake	1		snake	1
Create or Edit a Quote

 

[uk747]

thanks guys I'll use the 3 sumifs adding them together, you both suggested