Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total on a different page
I have a series of numbers corresponding to days taken off of work is there any way to take the sum of say each person on the sheets vacation days and subtract it from the total that they have left on a seperete sheet? -- DarklyCute1 ------------------------------------------------------------------------ DarklyCute1's Profile: http://www.excelforum.com/member.php...o&userid=35949 View this thread: http://www.excelforum.com/showthread...hreadid=558889 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total on a different page
Possibly you can use SUMIF() e.g. =Sumif($A$1:$A$100,"Johnny B.",$B$1:$B$100) Where A1:A100 contain the names of the employees and B1:B100 contain the number of vacation days -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=558889 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
For Hector Miguel - Inserting page numbers in cell | Excel Discussion (Misc queries) | |||
sum of total hours not correct | Setting up and Configuration of Excel | |||
Auto page numbering for several worksheets | Excel Worksheet Functions |