Inserting a row
You could slightly modify formula to:
=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"18 jan","25
jan"}&"'!B"&ROW(A10)&":H"&ROW(A10)),"hols"))
Now you have cell references determining the row number, and they will
adjust accordingly.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Pootle" wrote:
Hi
I have employee time sheets with a list of names with formulas attached to
adjacent cells to count holidays and sick. I want to know if there is a way
to insert a row so I could add a new name but also so the formula follows the
name.
The formula I have is:
=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"18 jan","25 jan"}&"'!b10:h10"),"hols"))
So I need the b10:h10 to move down automatically to b11:h11.
Any ideas greatly appreciated.
|