# 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

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))

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

.. or possibly just this?

=SUM(B2:B5)-SUM(A2:A5)

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)

thank you