I am trying to write a simple code for a time log file in excel. on
sheet1("time log") i have four columns (headers are Date, Client, Time,
Staffer). on sheet2 ("totals"), column A has a list of all of the clients and
columns B through M have the months of the year.
i would like for people to be able to enter in all of the info into sheet1
and then for sheet2 to automatically total the hours according to the right
client and under the right month in which the services were performed.
I have tried the following formula but it doesn't seem to work properly:
=IF((MONTH(C$2)=(MONTH('Time Entry'!$A:$A))),SUMIF('Time
Entry'!$B:$C,$A15,'Time Entry'!$C:$C),)

can someone help me with this??