Hi, I'm struggling in setting up the formula for my scorecard.
This is the scorecard for my team. I want it to show up the scorecard with total number when no criteria selected in a table. For example
Sales Team Customer Revenue
Johnny ABC $100k
Johnny BDE $50k
Sharon XFG $20k
Sharon PSR $60k
=IF(AND(SUMIF(A2:A4,"<>",C2:C4) & IF(AND('SUMIF(C2:C4,A2:A4,"Sharon") & IF(AND('SUMIF(C2:C4,A2:A4,"Johnny")
Not sure can this be done and hope any of you can advice me the correct formula. Please forgive me if I'm asking a stupid question. Thanks in advance!
Bookmarks