Forum Discussion
Solved
Excel: SUM and SUMIF
Hi all, I am preparing an excel file and I have an issue with the SUM formula. In the file, I added a checkbox that will give 0 if FALSE (not ticked) or 125 is TRUE (ticked). For this I used ...
SVS1989 As mentioned, you need to get rid of the #VALUE! errors. Then your formula works, although it can be simplified as shown in the pictures I uploaded. See attached.
This is the link to the file: https://1drv.ms/x/s!Ao3vdZZCM5g3igVKHaTEg0HYdE2x?e=3FgJKv
SVS1989 As mentioned, you need to get rid of the #VALUE! errors. Then your formula works, although it can be simplified as shown in the pictures I uploaded. See attached.