return number based on a value in a specific cell

**florin119** · 03-19-2022, 06:39 AM

Hello everyone!

I have a work hour sheet where If an employee is on duty "D" on Saturday, Sunday or Holiday day, under "D" should be 0 (zero)/blank cell, if is on duty "D" on the rest of the week (except Holyday day) under "D" should be 8 in order to calculate the work hours in that month in cell B8.

Thank you!

**Fluff13** · 03-19-2022, 11:09 AM

How about

Formula:

Please Login or Register  to view this content.

**CARACALLA** · 03-19-2022, 11:24 AM

Attendence

AI7=SUMPRODUCT((ISNA(MATCH('Attendence Dashboard'!$C$6:$AG$6,Holiday,0)))*(WEEKDAY('Attendence Dashboard'!$C$6:$AG$6,2)<=5)*(ISNA(MATCH('Attendence Dashboard'!$C7:$AG7,'Attendence Dashboard'!$W$18:$W$19,0)))*('Attendence Dashboard'!$C7:$AG7<>""))*8

Copy down

**florin119** · 03-19-2022, 11:36 AM

Thank you Fluff13 for your expertise. It works very well! You are a lifesaver!

**florin119** · 03-19-2022, 11:38 AM

Thank you CARACALLA for your expertise. It works very well! You are a lifesaver, twice in one day!

**Fluff13** · 03-19-2022, 11:38 AM

Glad to help & thanks for the feedback.

**CARACALLA** · 03-19-2022, 11:58 AM

You are welcome

return number based on a value in a specific cell

LinkBack

Thread Tools

Rate This Thread

Display

return number based on a value in a specific cell

Re: return number based on a value in a specific cell

Re: return number based on a value in a specific cell

Re: return number based on a value in a specific cell

Re: return number based on a value in a specific cell

Re: return number based on a value in a specific cell

Re: return number based on a value in a specific cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Assistance to return a specific number or result of 2 cell addition

[SOLVED] Return a specific value if a cell contains only a number

Return Certain Data Based On a Specific Number Needed

Return Number of Unique Valued Based On Specific Text

[SOLVED] Return a specific date based on another cell

[SOLVED] If specific text is found in cell, then return a number

[SOLVED] Search for a number in a table and return data of a specific cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions