Sumifs criteria range with row and column

[silambarasan.J]

Dear Forum Leader,

Sheet 1Time Sheet)

Row Range : A2:A378- Date

Column Range: B1:J1- Names

Column Range: B2:J378- Working hours

Sheet 2 : (Payslip)

How do sumifs one sheet to another sheet when criteria ranges meet both of column and row

[FDibbins]

I think it would help if you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[silambarasan.J]

FDibbins;

Thank you so much for quick reply

as requested to you please delete the this thread due to unclear thread title. I have started another thread. sorry for the convenience.

[FDibbins]

Thanks for the file, although you could have attached it here

I will close this now
https://www.excelforum.com/excel-for...nd-column.html

[6StringJazzer]

Sorry, we got our signals crossed here. I closed the later thread as a duplicate, and added the attachment and title change to this one and then found it closed so I reopened it.

silambarasan.J, if you have to make a change, edit the existing thread rather than open another copy of it. We discourage duplicate threads.

[silambarasan.J]

Thank you for your immediate action.

[silambarasan.J]

Please help me. Sample work book attached.

[JohnTopley]

Try

=SUMPRODUCT(('TIME SHEET'!$B$1:$J$1=$B4)*('TIME SHEET'!$A$2:$A$397>=PAYSLIP!$C$2)*('TIME SHEET'!$A$2:$A$397<=EOMONTH(PAYSLIP!$C$2,0))*('TIME SHEET'!$B$2:$J$397))

OR

=SUMIFS(INDEX('TIME SHEET'!$B:$J,,MATCH($B4,'TIME SHEET'!$B$1:$J$1,0)),'TIME SHEET'!A:A,">=" & $C$2,'TIME SHEET'!A:A,"<=" & EOMONTH($C$2,0))

[silambarasan.J]

Thank you so much for your help Mr.JohnTopley. Both of formula working fine way.

Thank a lot.