Hi,
I am design a formula that is easy to drag to the right.
It is interrogating 2 columns for each person (an am and a pm) to count holidays.
The formula is
=COUNTIF(Holidays!C:D,Balances!$B6)/2
B6 is just "Hol" which it is meant to calculate.
If I drag this across it is
=COUNTIF(Holidays!D:E,Balances!$B6)/2 rather than =COUNTIF(Holidays!E:F,Balances!$B6)/2
I just can't seem to find an easy way to resolve this.
Thanks as always
Kind Regards
Paul
Last edited by pdauction; 12-15-2015 at 08:39 AM.
have you tried adding $ to the first part of your formula? =COUNTIF(Holidays!$C:$D,Balances!$B6)/2
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thanks - unfortunately that keeps them all as $C:$D rather than changing to E:F and so on.
Oh, you want to move it one column to the right but have it jump 2 columns over, is that what you want?
=COUNTIF(OFFSET(Holidays!$C:$D,,COLUMN(A1)*2-2),Balances!$B6)/2Try this
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks nflsales, that's worked.
Sorry for not being clearer Sambo kid.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks