Help with a cont.se idea

Question

Hello there!

Consider this for example (Date/buy/sell) :

In the buy/sell cells i place the numbers manually on a dailly basis, so I want to automatize this procidure.
I Thoght of:

=CONT.SE('Database Grad'!E:E;"The cell of the date, in the example case B170")

But it doesnt work unfortunaly.
It works if =CONT.SE('Database Grad'!E:E;"04/01/2021"), but this doesnt help at all, since i would have to change the "date" to all cells mannually.

OBS.: this is a table source for a dynamic table in other sheet

Any ideas on how to make this work?

Thank you!!

Answer 1

@Luis

Did you use double quotes on the cell B170 in formula?
I tested that, if using double quotes on the cell B170, the formula will not work.

So please try to replace the date in formula with cell, like replacing "04/01/2021" with cell B170 without double quotes on it.

You could refer to the example given below.
Data is listed like below screenshot.
Use the formula =COUNTIF(E:E,A2).

Then drag the lower right corner of cell B2 to B7.
This step is to quickly copy the formula to other cells.

Then you will see formula updates automatically.

The sell column is as the same.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.