Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
attendance based pay for Army reserve
I am attempting to build a spreadsheet to manage attendance based pay for a
TA (National Guard equiv) squadron. Soldiers will be marked in either 0.25, .5, .75 or 1 for the percentage of working day attended and I want to produce a sum per month and rolling year however when I try to add the values of 31 cells Excel 2002 tells me I am entering too many arguments for Sum. To make things a little harder the cells for the dates are not next to each other so the formula should look like this =SUM(BO3,BM3,BK3,BI3,BG3,BE3,BC3,BA3,AY3,AW3,AU3,A S3,AQ3,AO3,AM3,AK3,AI3,AG3,AE3,AC3,AA3,Y3,W3,U3,S3 ,Q3,O3,M3,K3,I3,G3) Am I trying to do this the hard way ? Thanks Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
attendance log | New Users to Excel | |||
Need to create attendance tracking based on % and 2080 hours/year | Excel Discussion (Misc queries) | |||
Download An Open Letter From Al-RASHEDEEN Army To The American President | Excel Worksheet Functions | |||
*Salvation Army* Importing information from one workbook to another | Excel Discussion (Misc queries) | |||
How do I set up a equipment replacement reserve schedule | Excel Worksheet Functions |