Oh damn well now i wished i used my actual formula :) Used that one for
simplicity but have no idea how to apply that to mine so can you help me out?
:)

So it looks like this:

In cell G9 it is: =COUNTIFS('FNB HR'!O:O,A9,'FNB HR'!B:B,"FNB")
In cell N9 it should be: =COUNTIFS('FNB HR'!O:O,A9,'FNB HR'!B:B,"FNB",'FNB
HR'!Q:Q,"Yes")

etc...

So basically what i do now is i double click G9, then copy the actual
formula text, then double click N9 and paste it and hit enter and then i just
kinda add that last bit manually :)

*gulp*



"Jacob Skaria" wrote:

Use absolute referencing

=$A$1+$A$2

Below are the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

If this post helps click Yes
---------------
Jacob Skaria


"ant1983" wrote:

Scenario:

A1 + A2 = A3

so in A3 i have "=A1+A2"

So if i want to copy that formula in lets say B3 then it would adapt the
reference so it would ready "=B1+B2"

I dont want that - how can i keep that original refernces wherever i copy
the formula?