G
G
gfuzeev2020-11-01 15:14:36
Google Sheets
gfuzeev, 2020-11-01 15:14:36

Why does the same formula in google sheets work in one cell and not in another?

It's about the SUMIFS formula:
The same range for conditions, adjacent ranges for summation, the formula is simply stretched over several cells and counts somewhere, but not somewhere.

https://docs.google.com/spreadsheets/d/1w2rnhfR1V2...

Column "A", for example, cells A6 and A7

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2020-11-01
@gfuzeev

We messed with the cell format. Set all cells to "Auto Format" (see "Format" menu).
5f9ee533a347d498798478.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question