Forum Discussion

Summer580's avatar
Summer580
Copper Contributor
Jul 19, 2021

Spreadsheet calculations

I'm trying to pull data from one sheet to another within a excel spreadsheet.

Example: formula is =+COUNTIF(JULY!$D2:E989,B3)

I need the calculating column to pull data from the 'July' tab always starting with column D2:E989 from 'JULY' tab. 

I try to copy & paste the formula but it then auto calculates by changing each line

example; for each line it changes to 

=+COUNTIF(JULY!$D3:E989,B3)

=+COUNTIF(JULY!$D4:E989,B3)

=+COUNTIF(JULY!$D5:E989,B3)    etc...

How can I copy this formula to 618 lines without the formula changing?