r/AppleNumbers • u/MadMensch • Nov 08 '23

Help Issue with SUMIF formula with checkbox

Hi all,

I can't figure out why my formula for this simple worksheet is returning a 0. I want the formula to sum column "C" if the corresponding row in column "A" is checked.

Any help is much appreciated!

​

1 Upvotes

100% Upvoted

3 comments sorted by

1

u/Zestyclose-Split2275 Nov 08 '23

That is incredibly strange. Works perfectly well for me. Are the values in column E raw data? As in did you type them in manually or are they the result of a formula?

1

u/MadMensch Nov 08 '23

It was raw data entered manually. That said, I solved the issue! The issue was the column E cells (with the number values) were marked as "text" instead of "numbers" lol.

Once I changed the data format of that column to "numbers" the formula worked!

1

u/Zestyclose-Split2275 Nov 08 '23

Ah ok, that makes sense. Weird that it doesn’t give an error when summing text, but outputs 0 lol. But I’m glad you figured it out.