SUMIFS Issue

Patti

Hi,

I have a client master list on my Smartsheet and I want to get the total monthly fee of those clients that have an "Active" status

Both the monthly fee and status are in my Smartsheet and when I tried using =SUMIFS(MONTHLYFEE:MONTHLYFEE,STATUS:STATUS,”Active”) I got an #UNPARSEABLE error.

Please help. Thanks!

 

 

Andrée Starå

Hi Patti,

It's your right double quotation marks that are wrong. It should be ordinary quotation marks instead.

Try this one.

-=SUMIFS(MONTHLYFEE:MONTHLYFEE, STATUS:STATUS, "Active")

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting