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

[Guest]

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
(e-mail address removed)

 

[Don Guillett]

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)