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