S
S
senseninja2020-02-07 01:05:34
Autocomplete
senseninja, 2020-02-07 01:05:34

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

1 answer(s)
S
senseninja, 2020-02-07
@senseninja

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 question

Ask a Question

731 491 924 answers to any question