Spreadsheet calculations

New Contributor

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? 

2 Replies

@Summer580 

Perhaps =COUNTIF(JULY!$D$2:$E$989,B3)

Thank you I will try that