Sum Based on Value

Beronica Muller

Hello,

I am trying to use a formula to calculate the number of inquiries created based in a particular column.  For example, I am trying to get the total number of inquiries that have been assigned to the responsible area NAOPS.Priority.  I tried using the =SUM formula but it is giving me the overall total and not the total for that particular area.   I have attached a screenshot for review.

Paul Newcome

My apologies. Wrong function. Ugh. Apparently I need a little more coffee this morning...

=COUNTIFS({Other Sheet Name Range 1}, "NAOPS.Priority")

Beronica Muller

YAY!! It worked... Thanks Paul, I owe you a Venti from Strabucks!

Andrée Starå

@Beronica Muller

I saw that Paul answered already!

Let me know if I can help with anything else!

Best, 

Andrée 

Jeff Reisman

Try using the SUMIF function instead.

=SUMIF([AssignedColumn]:[AssignedColumn], "NAOPS.Priority")

Beronica Muller

Unfortunately, this is not working as well.. I am getting an error message #UNPARSEABLE. I am not sure what I am doing wrong. Uggghhh, please help!

Paul Newcome

Can you provide a screenshot with sensitive/confidential data removed, blocked, or replaced with "dummy data" as needed as well as copy/paste your original formula?

Andrée Starå

@Beronica Muller

Hi Beronica,

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Beronica Muller

Responsible Area.png

Responsible Area 2.png

Responsible Area 3.png

Please see attached.

Paul Newcome

If the data is on a different sheet, you will need to make your range a cross sheet reference.

Type in:

=SUMIFS(

Then click the blue link in the help box that says "Reference Another Sheet". Select the sheet the data is on, click on the column header for the column you want to sum, then click the blue box in the bottom right corner that says "Insert Link".

You should now see...

=SUMIFS({Other Sheet Name Range 1}

Then you can enter the rest of your formula.

=SUMIFS({Other Sheet Name Range 1}, "NAOPS.Priority")

Beronica Muller

Thanks Paul,

I tried that as well and was not successful. Please see attached.

Smartsheet is not in my favor today! :-)

sumifs.png

Beronica Muller

sumifs2.png

Paul Newcome

My apologies. Wrong function. Ugh. Apparently I need a little more coffee this morning...

=COUNTIFS({Other Sheet Name Range 1}, "NAOPS.Priority")

Beronica Muller

YAY!! It worked... Thanks Paul, I owe you a Venti from Strabucks!

Paul Newcome

Haha! Happy to help! 👍️

Andrée Starå

@Beronica Muller

I saw that Paul answered already!

Let me know if I can help with anything else!

Best, 

Andrée