Welcome!

SumIF Not Working

Jim Schaffhausen

Hi There-

I am typing in the formula per the attached screenshot correctly, however it is returning the sum of 0. Any ideas?

Thanks-

Jim

Find more posts tagged with

Comments

Mike Wilday

Try Countif. Sumif works if you are summing columns of numbers, what you are trying to do is count how many times teh 0001-Aparell Accessories appears.

=Countif(Pyramid:Pyramid, "0001 - Apparel Accessories")

For sumif, you also have to add the column to add up together.

dwayne.waterman21236

Jim, I think you have to use the =countif function.

Jim Schaffhausen

Thanks! It worked perfectly!

Mike Wilday

Glad I could be of help. I keep this post on tap for whenever I need it!

https://help.smartsheet.com/functions

Sign in to join the conversation!

Quick Links

Trending discussions

publish link for non licenced users in my workspace no longer allows them to tag me or edit
We changed from an enterprise licence to specific accounts. I have a licence and setup a workspace for our global team to edit and collaborate across various sheets. I granted editor can share rights to all non licensed members and shared the publish link with them. This has worked well and allowed them to edit cells,…
Names not emails as titles
This is pulled from a column of responsible person. Why does it display email and not name. How do I correct?
Set Default Value in Form that is NOT a Dropdown Value
Hi! I have a sheet that has two form that feed into it. This is to report on Closures due to Staffing, Weather, and Facilities. One team submits closures for Staffing and Weather, while another team only submits Facilities. When I created this set up I have it so the one team gets asked "Reason?" then they can select…