Total on a different page

D

DarklyCute1

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:
 
V

Vito

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
 
Top