SOLVED

New Contributor

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

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

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

Do you mean

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

?

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

i will try it, im new to exel so im not sure of its capabilities

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

yep that worked fine thanks!

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

@CaptainCaveman , you are welcome

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

Yes. How do that?
=SUM(F3:F21) - SUM(G3:G21)