MATCH and OFFSET help

[new guy]

I hope this makes sense

My current formula is
=IF(ISNUMBER(MATCH(K$3,OFFSET($AD$7:$AS$7,MATCH($I6,$AC$8:$AC$21,0),0),0)),"V","")
(which shows when someone has a day off)

Attached is my workbook, I need to add to the formula
to also check for a MATCH in cells BG8:BU21 and insert a "W", and then also add 1 to the total on shift rows.
(which will show someone working their day)

and then in the total on shift cells, I have
=SUMPRODUCT(NETWORKDAYS.INTL(K$3,K$3,$J$6:$J$11))-COUNTIF(K$6:K$11,"V")
witch subtracts 1 from the total if there is a "V"

I need to modify this to add 1 to the total on shift if there is a "W" I assume it will be
=SUMPRODUCT(NETWORKDAYS.INTL(K$3,K$3,$J$6:$J$11))-COUNTIF(K$6:K$11,"V")+COUNTIF(K$6:K$11,"W")

[XLent]

for the matrix, I'd change approach (to avoid OFFSET)

Please Login or Register  to view this content.

In terms of the aggregate, yes, that would work - as long as you have a robust approach to your data mgmt (e.g. no W if working day, no V if non-working)
(if not you could build into the SUMPRODUCT test itself)

[new guy]

That works, Thank you-, I seriously don't know how you guys know all this stuff, I wish I could think like that.
anyway thanks again!!