BenGrobler
New Member
- Joined
- Apr 19, 2021
- Messages
- 31
- Office Version
- 2019
- 2016
- Platform
- Windows
I have a formula that starts in Column"O" , each time i process data that is captured in Column "O" then a new column is inserted for the next data.
My Formula is =COUNTIF(O4:XFD4,"Cool") after inserting the new column my formula is =COUNTIF(P4:XFD4,"Cool")
i need it to stay the same after inserting a new column?
My Formula is =COUNTIF(O4:XFD4,"Cool") after inserting the new column my formula is =COUNTIF(P4:XFD4,"Cool")
i need it to stay the same after inserting a new column?