Copy Multi Formula and then freeze cell refs before second copy

[Trig79]

Hi All

i have set up a basic COUNTIF formular:

=COUNTIF('Jan CM'!B:B,Sheet1!A283)

Note: Jan CM relates to sheet 2.

I have copied this formular down through 250 rows. This works perfect and the ref A283 changes as i go.

My next challenge is to copy all those formular left to right. BUT i need to freeze the column refs A283...A284...A285 etc

I am aware i can do this through using the dollar sign but is there a way to multi update the formulars i have copied down?

The only way i can find to achieve the above is to go down every indivdual line and insert the $ sign. Before i attempt to copy acoss my worksheet

all help appreciated

[teylyn]

before copying down, change the initial formula to


=COUNTIF('Jan CM'!B:B,Sheet1!$A283)

then copy right

If that does not help, post a sample of your data. Click "Go Advanced" below and then the paper clip icon to attach a file.

cheers

[Trig79]

The answer is always so simple!!!

thank you for your help

[teylyn]

Glad it worked for you. Please mark the thread as solved!

cheers