Answer the question
In order to leave comments, you need to log in
Google Spreadsheets: how not to change part of the data when autofilling?
There is the following function that counts the number of rows that match the requirements:
= COUNTIFS(D2:D188288; ">100"; E2:E188288; "OK";A2:A188288; L3; B2:B188288; ">"&O3; B2:B188288 ; "<"&O4)
1) in column d we take into account all the data from d2 to d188288), we look for >100
2) in column E we take into account all the data from e2 to e188288), we look for the text OK
3) in column A we take into account all the data from a2 to a188288), we are looking for > the value specified in O3
4) in column B we take into account all the data from b2 to b188288), we are looking for it to be < the value specified in O4
When I drag and drop to autocomplete to other lines, I need O3 and O4 to change to O4 and O5 and so on (it works), but as for a2: a188288, b2: b188288, both values also change with each new line. How can I change only O3 and O4 values?
Answer the question
In order to leave comments, you need to log in
D$2:D$188288 As far as I understand it is enough to add $ before the number
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question