Thread: Is there a SUM-minus formula instead of SUMPRODUCT? Thanks: 0 Likes: 0

1. Is there a SUM-minus formula instead of SUMPRODUCT?

Hiya guys

Im after a formula that essentially does a sumproduct but instead of multiplying i want to take away

ie im after =sum(B2-A2,B3-A3,B4-A4,B5-A5) etc  Reply With Quote

2. Re: Is there a SUM-minus formula instead of SUMPRODUCT? Originally Posted by Siyanna Hiya guys

Im after a formula that essentially does a sumproduct but instead of multiplying i want to take away

ie im after =sum(B2-A2,B3-A3,B4-A4,B5-A5) etc
Control+shift+enter, not just enter:

=SUM(IF(ISNUMBER(A2:A5*B2:B5),B2:B5-A2:A5))  Reply With Quote

3. Re: Is there a SUM-minus formula instead of SUMPRODUCT?

.. or possibly just this?

=SUM(B2:B5)-SUM(A2:A5)  Reply With Quote

4. Re: Is there a SUM-minus formula instead of SUMPRODUCT?

Although I think Peter's SUM-SUM is the efficient way to do it in this case, there might be some value in learning how to use SUMPRODUCT effectively.

=SUMPRODUCT(B2:B5 - A2:A5)  Reply With Quote

5. Re: Is there a SUM-minus formula instead of SUMPRODUCT?

thank you  Reply With Quote

User Tag List

Tags for this Thread

essentially, formula, guys, multiplying, sumproduct  Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•