M
M
Marchela2022-03-15 11:30:18
Google Sheets
Marchela, 2022-03-15 11:30:18

How to make Google Sheets display the price separately for each drop-down list in a cell?

62304e60a197c288716872.jpeg
So I want to add another item for performers, and so that the green cell displays its own amount for each when choosing

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2022-03-15
@Marchela

I hope I understood you correctly
62309fc48977b301783019.png
=SUMIF(E:E;J1;I:I)

  • E:E- what we check
  • J1- what we check for, condition
  • I:I- what we sum up

M
Marchela, 2022-03-21
@Marchela

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question