M
M
Marchela2022-03-22 11:10:52
Google Sheets
Marchela, 2022-03-22 11:10:52

How to make it so that the amount is displayed when you click the checkmark?

Good afternoon! Another question arose.
Previously, when you clicked the checkmark, the price was displayed.
6239846f19ea9470571311.jpeg
Now I also wanted to do the same, what should I add for this?
6239848a8ce4b990215110.jpeg
This is the formula now
. When adding also (B:B;TRUE;), an error occurs

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2022-03-26
@oshliaer

623f70edc101d149425915.png
Try SUMIFSinsteadSUMIF
=SUMIFS(H:H;B:B;TRUE)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question