sumif

[uk747]

try to add colums where the previous column matches another celli.e. in column A, H and J i have a list of things in the next column B,F and K have a list of numbersso whenever dog appears in column A H or J i want it to add the number next to it. I tried the formula below but said too many arguments for this function=sumif(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 #

 

[uk747]

If Sumif cant be done would a sumproduct be better

 

[uk747]

Bump