Sumif Formula using data on another sheet

[brianfosterblack]

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

 

[etaf]

i have answered your other question with a solution
SUM() with a VLOOKUP() and Array , and using an indirect to get the sheet name from the header
=SUM(VLOOKUP($C4, INDIRECT("'"&D$3&"'!$A$6:$AI$30"),{5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35}, FALSE))

BUT as i say see your other question

see here

Total time spent with client

so I want to know if I can do this as a formula or do I need to run a macro I want to add up the time spent on each client in each month On my "Clients" Sheet I have all my client listed in Column C from row 4 downwards In row 3 from columns "I" to "T" I have the 12 months starting from Mar and...

www.mrexcel.com

 

[Fluff]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.