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.
Hi,
Try this instead:
=IF(K21=TRUE,SUM(J26:J35)+125,SUM(J26:J35))
You can change the 125 with your reference to M21 if you wish.
- Thank you very much, Martin.
However, it does not seem to work 😞Does it give you an error? Which one?
Can you try to share a sample file without sensitive data or specify why it does not work?
- This is the link to the file: https://1drv.ms/x/s!Ao3vdZZCM5g3igVKHaTEg0HYdE2x?e=3FgJKv
