Need to tell excel to add up specific cells

  • Thread starter Thread starter buachille
  • Start date Start date
B

buachille

Hi,

We run a small business and i do the invoices and quotes etc. I use
excel for our invoice record. It took me ages to figure out how to set
it up so that i could enter the net amount of our bill and have excel
add the vat, show the vat in its own column, then put the total of the
two in another column, and show a grand total of all 3 columns down at
the bottom of the sheet.

so you will have guessed by now that i am no expert!! :(

i want excel to give me a total of our unpaid bills without me having
to do an autosum every time.

i have the unpaid bills marked, in the cell to their right, as
\"unpaid\" in red (conditional formatting tells excel to colour the
word unpaid as red).

what i want to do is tell excel to automatically add up all the figures
that have unpaid to their right, and put the total in a cell i choose.

i suspect i may not have explained myself too well so i've uploaded a
picture of the spreadsheet (a small section of it) with some
explanatory notes on it. If anybody would like to take a look 'here is
the link' (http://www.buachille.dsl.pipex.com/excel_sheet.jpg)
 
Assuming your status column is C and your amount column is D
This might do what you want........

=SUMIF(C:C,"UNPAID",D:D)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top