=sumifs formula issue

[fmxwannabe]

Hi All,
Hoping somebody could please help me. I'm using a SUMIFS formula however it keeps returning $0.00 as the result which is incorrect.

Formula is;

=SUMIFS(B:B,A:A,"=325299",A:A,"=325300",A:A,"=325303")

Can somebody tell me what I'm doing wrong and provide an anwser to get this to work?

Thanks
Zane

 

[Tony Miall]

what exactly are you trying to do?

 

[Weazel]

maybe something like...

=SUM(SUMIF(A:A,{325299,325300},B:B))

 

[teylyn]

Hello,
are you trying to do a series of conditions with OR as the logic? If so, see here

http://www.mrexcel.com/forum/excel-questions/630118-sumifs-condition.html

This would make your formula something like

=SUM(SUMIF(A1:A20,{"=[COLOR=#333333]325299[/COLOR]","=[COLOR=#333333]325300[/COLOR]","=[COLOR=#333333]325303[/COLOR]"},B1:B20))

If the values in column A are numbers, you can use

=SUM(SUMIF(A1:A20,{[COLOR=#333333]325299[/COLOR],[COLOR=#333333]325300[/COLOR],[COLOR=#333333]325303[/COLOR]},B1:B20))

cheers, teylyn

 

[vogel997]

I can't figure out why Sumifs doesn't work, but try this one

=SUMPRODUCT(--(A:A=325299)+--(A:A=325300)+--(A:A=325303),B:B)

 

[Weazel]

Just an alternative if you wanted to put the criteria in individual cells....

=SUMPRODUCT(SUMIF(A3:A10,F1:F2,B3:B10))

where F1:F2 would contain 325299 and 325300