Forum Discussion
Summer580
Jul 19, 2021Copper Contributor
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?
2 Replies
- SergeiBaklanDiamond Contributor
Perhaps =COUNTIF(JULY!$D$2:$E$989,B3)
- Summer580Copper ContributorThank you I will try that