How do I set up an income calculator on excel that specifies clie.
 

I am new to excel and am trying to figure out how to build up a spreadsheet
that would calculate my monthly or even yearly income. I would like to
include this data

Client Name
Dates or months (I can fill this in)
Amount paid

I would love to have the spreadsheet do the calculations for me,

I need help

Lizette

How do I set up an income calculator on excel that specifies clie.
 

just set up with
col a client name
col b date paid
col c amount
then look in HELP index for SUM to total for the year if only one year shown
in database
use SUMIF for the month
or I like
=sumproduct((year(b2:b200)=2005)*(month(b2:b200)=3 )*c2:c200)

--
Don Guillett
SalesAid Software

"help" wrote in message
...
I am new to excel and am trying to figure out how to build up a
spreadsheet
that would calculate my monthly or even yearly income. I would like to
include this data

Client Name
Dates or months (I can fill this in)
Amount paid

I would love to have the spreadsheet do the calculations for me,

I need help

Lizette