SOLVED

i wish to total 2 columns then subtract the 1 total from another total how?

Copper Contributor

further detail

 

hi have 2 columns, i total the 2  =SUM(G3:G21) =SUM(F3:F21) for example

 

now those totals are generated G=2000 and F=1000

 

i want the totals generated to then F-G =1000 

i want all this to happen and have the result posted in one box

 

5 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@CaptainCaveman 

Do you mean

=SUM(F3:F21) - SUM(G3:G21) 

?

i will try it, im new to exel so im not sure of its capabilities
Yes. How do that?
=SUM(F3:F21) - SUM(G3:G21)
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)