Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Income Tax using US Tax System Excel WorkBook | New Users to Excel | |||
Dual income calculator help | Excel Worksheet Functions | |||
Interest Income Calculation in Excel | Excel Discussion (Misc queries) | |||
formula for workbook showing daily income compared to goal income. | Excel Worksheet Functions | |||
How do I project monthly income in Excel? | Excel Discussion (Misc queries) |