Help with SUMIFS function

[Benjamin Baites]

Hey guys, I have a simple question but is has me stumped.

I'm trying to calculate the total quantity of a certain product in stock.

For example: [IMG=http://img707.imageshack.us/img707/7259/guitarsh.th.jpg][/IMG]
Uploaded with ImageShack.us

If I wanted to get the total quantity of guitars that are Classical, Sandwood and Multi how would I do it??

I tried: =SUMIFS(F4:F14,B4:F14,"Classical",B4:F14,"Multi") and a few other variations but it isn't working at. Any ideas?

Thanks heaps.

 

[Haseeb Avarakkan]

hello, Welcome to MrExcel.

Try

=SUMIFS(F4:F14,B4:B14,"Classical",C4:C14,"Sandwood",C4:C14,"Multi")

See the below link,

http://www.excel-examples.com/sumifs.htm

 

[Aladin Akyurek]

Hey guys, I have a simple question but is has me stumped.

I'm trying to calculate the total quantity of a certain product in stock.

For example: [IMG=http://img707.imageshack.us/img707/7259/guitarsh.th.jpg][/IMG]
Uploaded with ImageShack.us

If I wanted to get the total quantity of guitars that are Classical, Sandwood and Multi how would I do it??

I tried: =SUMIFS(F4:F14,B4:F14,"Classical",B4:F14,"Multi") and a few other variations but it isn't working at. Any ideas?

Thanks heaps.

You need create a term for the range to sum and a conditional term which involves a relevant range...

=SUMIFS($F$4:$F$14,$B$4:$B$14,"Classical",$C$4:$C$14,"Sandwood",$D$4:$D$14,"Multi")

 

[Benjamin Baites]

Thanks alot for the quick reply. I really appreciate it!!

I think I saw where I went wrong. I also forgot the '$' rookie mistake.

Cheers alot!