Good afternoon,
I am building a new timecard that has each month (and employees) on a separate sheet. There is one summary sheet, which I have a dropdown to indicate the employee as well as another dropdown with the month I would like to summarize. There are two separate counts (vacation days and sick days) that I would like to bring over dependent on the month but can't figure out the correct formulas to use. I have started here:=IF(C1="July",(SUMIF(July!A:A,'Signature Sheet'!B3,July!AB:AB))), - where B3 is the employee's unique identifier - and now I need to figure out how to differentiate the remaining months.
Any help would be much appreciated and if this needs clarification please let me know.
Cheers,
T
I am building a new timecard that has each month (and employees) on a separate sheet. There is one summary sheet, which I have a dropdown to indicate the employee as well as another dropdown with the month I would like to summarize. There are two separate counts (vacation days and sick days) that I would like to bring over dependent on the month but can't figure out the correct formulas to use. I have started here:=IF(C1="July",(SUMIF(July!A:A,'Signature Sheet'!B3,July!AB:AB))), - where B3 is the employee's unique identifier - and now I need to figure out how to differentiate the remaining months.
Any help would be much appreciated and if this needs clarification please let me know.
Cheers,
T