I can't figure out why this formula won't work. The range and criteria are dates (ie: 01/15/05) and the Sum_Range refers to hours worked.
=SUMIF('January 05'!A6:A67,'Carol''s Payroll Sheet'!A1:A14,'January 05'!D6:D67)
I keep getting a 0 for my answer or it only calculates some of the hours worked.
As you can see, I am using 2 different worksheets...though I don't think that's the problem!?!?!
=SUMIF('January 05'!A6:A67,'Carol''s Payroll Sheet'!A1:A14,'January 05'!D6:D67)
I keep getting a 0 for my answer or it only calculates some of the hours worked.
As you can see, I am using 2 different worksheets...though I don't think that's the problem!?!?!