Tax return spreadsheet...

J

Jacob

Good day all!

I've created a spreadsheet that analyzes how our bank tallies up a person's
tax returns, line item by line item, to give us a workable income number at
the bottom.
I have the TOTAL ADJUSTED GROSS INCOME at the bottom, and I use the
SUM(A1:A45) function to get the total.
However, I want to designate certain cells along the A column to subtract,
not add to this total. There has to be an easier way to do it that
specifically write the formula in my total bar for each cell (- or +). Can i
create a way to designate "if this cell has a total then subtract it,
otherwise, add it"?

Thanks so much,
Jacob
 
P

Paul Corrado

If you use a helper column

Put 1 for the items to add and -1 for the items to subtract

Then use (with data to add in C and helper column in A

=SUMPRODUCT(C1:c10,A1:A10)

Adjust range as needed
 
Top