Simplifing multiple formulas to one formula.

Hi!
I want please help. I provide an image as example (in attachments)

The C1 is the difference from B1 and A1 (=B1-A1), but if both B1 and A1 are numbers (>0), B1 > A1. In other cases the result is 0. I put a formula in C1 myself:

Please Login or Register  to view this content.

and for all cells of C, of course, till the end of the table.

In the end i put formula to sum all the values:

Please Login or Register  to view this content.

But is a way to put only one formula in C7 to sum all the values of the differences from B and A please? I have a big table and i have different rows and columns. It take a big time to put the formulas in all the cells. My whole table is in the same syntax as is in example: a row with numbers, the next is with text and after again numbers and so on.


Please help.

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

This?

=SUM(IF(B1:B6>A1:A6,B1:B6-A1:A6,0))

Thank you very much.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Try this:

=SUM(IFERROR(IF(B1:B6>A1:A6,B1:B6-A1:A6,0),0))

And then please mark the thread as solved as described above. Thanks.

Thank you very much!

You're welcome.