Google Sheets: Formula I can use with multi conditions

[CullyM]

Hello!

I am working on a project for a non-profit to help with their inventory. I made a app and I synced it to Google Sheets and am trying to come up with a formula I can use with 3 conditions.

Daily List.PNG

Here is one of the lists, I need to be able to add the groups together, : (Dog / Adult / Kibble) or (Cat / Small / Can)

From that I also have a list of all inventory that needs to be subtracted to remove it out of the main inventory from the previous list.

Total( Dog / Small / Can) subtracted from previous total

Total.png

I hope I made since...

Thank You!!!

[FDibbins]

Not sure if this will work in DOCS (I dont use that), but this would work in excel...
=sumifs(B"B,""dog",C:C,"adult",D:D,"Kibble")

[CullyM]

Not sure if this will work in DOCS (I dont use that), but this would work in excel...
=sumifs(B"B,""dog",C:C,"adult",D:D,"Kibble")

Thank you for the response!
But I tried that but SUMIFS you can only use 2 conditions.
Like =SUMIFS(E:E,B:B,""Dog",C:C,"Adult"). I need something with 3 conditions. Google docs is just like excel I use it more than I do excel now!

[AliGW]

In Excel, SUMIFS can have lots of conditions. Are you saying it can only have two in Google Sheets? Or are you muddling it with SUMIF?