Sumifs count is off from column sum count. How can I fix this?

Natye Briggs
Natye Briggs ✭✭✭
in Formulas and Functions
image.png

I am attempting to match my sheet summary with the column sum of 1115 (seen at the bottom). The sheet summary is pulling the column "Fiscal DOD K-6 Hours" as 1172(on the right). The formula I am using is the following:

=SUMIFS([Total Hours - DOD K-6]$1014:[Total Hours - DOD K-6]$1333, [DOD - K-6]$1014:[DOD - K-6]$1333, 1)

I don't have any current conditional formatting running and I only filtered so you can see the data associated with the issue. What am I missing.

· Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭

    Even with a filter in place it is still counting the rows hidden between the rows you marked. If you filtered out anything that also has a check in [DOD - K-6] it is being counted as well.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter
  • Natye Briggs
    Natye Briggs ✭✭✭

    Thank you, I was able to figure it out.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!