Simple subtraction formula help for Numbers

Hi All - How do i subtract the sum of a group of cells from one other cell.


For example - I was hoping it was "=E11-(E13:E15)" but I'm getting an error message that says E13:E15 cannot be used as a single value.


What am I missing?


Thanks so much!


-G.



MacBook Pro 16″, macOS 11.3

Posted on May 14, 2021 11:00 AM

Reply
Question marked as Top-ranking reply

Posted on May 14, 2021 2:04 PM

Hi G


Try this:


E11-SUM(E13:E15)


Regards,

Barry

3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Simple subtraction formula help for Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.