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?

:confused:


--
DarklyCute1
------------------------------------------------------------------------
DarklyCute1's Profile: http://www.excelforum.com/member.php...o&userid=35949
View this thread: http://www.excelforum.com/showthread...hreadid=558889

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