My formulas on my Metric sheet are calculating 0 and I'm not sure why
Hello,
I am trying to create a dashboard with widgets to display our overall progression on multiple projects. I was told a Metric sheet would be best to do this. I am creating my first metric sheet but the formulas are calculating 0 and I'm not sure why. In the first section below I am wanting to add up how many projects are In Progress, Delayed, etc⦠I am linking to the status column on the Accounting Integration Deal Tracker sheet. Can someone look at my formula and see what I'm doing wrong? Thank you!!!
Best Answer
-
You are using a SUMIF function. This is used to add numbers together. It looks to me like you are more trying to count the number of instances in which case you would want a COUNTIF or COUNTIFS function instead.
Answers
-
You are using a SUMIF function. This is used to add numbers together. It looks to me like you are more trying to count the number of instances in which case you would want a COUNTIF or COUNTIFS function instead.
-
thank you so much that was it!
Help Article Resources
Categories
Check out the Formula Handbook template!