MS Excel "IF" help

[Norbert666]

This is difficult to explain.

To manage my accounts I keep a record in excel.

Across the top (simplified): (A)Fee; (B)invoice date; (C)Fee paid date

I fill in the respective cells as and when invoices are raised and then subsequently paid. I also record jobs that haven been invoiced yet.

eg.
job1; £1,000, 1 Jan 12, 21 Jan 12 (work done, invoiced and paid)
job 2, £1,000, 2 Feb 12, [blank] (work done, invoiced, not paid)
job 3, £1,000, [blank], [blank] (job not done, not invoiced, not paid)

At the bottom of the sheet I tally:
(1) Total fees invoiced
(2) Total fees paid

Up till now I've done it manually, but I'd like a formula to make my life easier.

IF theres an entry in B, its been invoiced so automatically added to total (1) above.

IF there's an entry in C, it's been paid so automaticaly added to total (2) above.

So in my simple laymans terms, there is an autosum at the bottom which tells me the total amount invoiced and another showing total amount paid.

Any idea how to do this? Or even what to specifically search for in Google?

 

[mattx2]

Try googling for sumif

If you can't get it to work I'll make an example sheet when I get home

 

[wonder_lander]

Depends on what you want. Me personally I would maybe expand it out to:

Job Name, Estimated Price, Invoice Date, Invoice Amout, Paid Date, Paid Amount

That will make it easy to add up invoice amount and paid amounts and will show if your estimating is off. It will also allow you to show up part payments or deposits.