A formula for totaling question

Rick Segal

I have a sheet that is tracking issues.  One column is a category (bug, feature req, UI issue, etc.).  The selections are defined in a pull down and isn't free form.  I want to create a widget for a dashboard that shows the total number of each category option.  It appears I can't do it directly so I thought of building a formula that creates numeric totals on a separate sheet and then charting that.  How to I create the formula to run through each row with if this, increment that or some such.  

 

Any thoughts/advice appreciated.

J. Craig Williams

Look at COUNTIFS.

https://help.smartsheet.com/function/countifs

Craig

(note: if you have only one criteria, COUNTIF also works, but I never use it because there is no reason to)

 

 

 

Ofir Marco

Hi Rick,

I have done something similar only with a column of risk level status (Values: "High", "Medium", "Low").

Created 3 columns, one for each value.

Here is an example of the formula i applied on the high Risk level column:

=COUNTIF([Risk Level]:[Risk Level], "High")

Then, i have created a chart that points on the results cells (See attachment).

Hope that helps.

 

Rick Segal

Thank you very very much.  Now neck deep in learning functions.  Documentation, who knew? 

Rick Segal

This is perfect. Like totally and completely what I was looking for.

Thank you very very much!

Rick

Ofir Marco

You're welcome!

Glad to know it helped.