brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I am probably using the wrong function as it does not work
=SUMIF(Mar!A6:A1000,C12,Mar!E6:AI1000)
I have the formula on a sheet named "Clients"
The first range is the range which contains my client names on the "Mar" worksheet
C12 is the client name (Criteria) in my list of clients on the "Clients" Sheet and the formula is on the same sheet in cell I12
The second range is the columns which contain the data which is the number of hours I have worked for that client in the format "[h]:mm"
Can anyone help or am I barking up the wrong tree with this function
=SUMIF(Mar!A6:A1000,C12,Mar!E6:AI1000)
I have the formula on a sheet named "Clients"
The first range is the range which contains my client names on the "Mar" worksheet
C12 is the client name (Criteria) in my list of clients on the "Clients" Sheet and the formula is on the same sheet in cell I12
The second range is the columns which contain the data which is the number of hours I have worked for that client in the format "[h]:mm"
Can anyone help or am I barking up the wrong tree with this function