Multiple True or False + Sum of corresponding cells

[CheezZZ]

Hey guys,

This is my first time here so thanks in advance to anybody who might be able to help

In a nut shell, I've got a mega excel sheet right now with multiple people making updates to it on a daily basis. As such I am trying to find a way to output various totals in a separate static table which i can grab at any point and be confident numbers are correct.

The problem, firstly I cant figure out how to have multiple true false formulas checking the sheet from 1 cell. i.e "Check column B True/False for RestrauntNameXYZ + Check column E for true/false GroupABC + check column G for true/false Lunch"

and thennnnnnn

Calculate sum of column A for all rows which above combinations of true/false checks spit out


I reaaally reallllly hope somebody understands what i mean lol

Thanks!

Mark C

[Mayhassen]

You can use sumifs. Sum range is A, and the criteria ranges are B, E and G with the respective criteria restaurant, group etc.

[CheezZZ]

Hey, thanks!!

Ive got this far:

=SUMIF(B2:B334;"Group1";C2:C334)

But im having trouble adding multiple criteria to the same formula... any ideas?

Thanks!

[CheezZZ]

Just to clarify, i want to add 2 further criteria to the existing formula... for example

E2:E334;"RestaurauntABC" and F2:F334;"Lunch"

added into

=SUMIF(B2:B334;"Group1";C2:C334)

But i cant seem to make it stick....

[Mayhassen]

Use sumifs, not sumif

[CheezZZ]

Thanks! i just cant seem to make it stick though. I have no idea where i am going wrong in the formula but it just wont go.

[Jonmo1]

The big difference between sumif and sumifS (besides that it can do multiple criteria)
Is that the range to sum comes FIRST in Sumifs, while it is LAST in sumif..

SUMIF(criteriarange,criteria,rangetosum)
SUMIFS(rangetosum,criteriarange,criteria,criteria2range,criteria2,criteria3range,criteria3)

Hope that helps.

[CheezZZ]

oh man! no wonder!! legend... ill try it when i get home...

Thanks a million guys!!