K
K
Kooper_pro2019-03-23 16:51:49
Google Sheets
Kooper_pro, 2019-03-23 16:51:49

How to count unique cell values ​​for the current week?

On one sheet there are, for example, several cells:
Date - where the date is indicated in the format 03/23/2019
And status - for example Status1, Status2, Status3
So how to calculate status2 values ​​​​for the current week?
I use:
=COUNTIFS(ISOWEEKNUM(DATEVALUE('Database'!C:C)); ISOWEEKNUM(TODAY());'Database'!L:L; "status2")

But it doesn't work, what should I do? The database is one sheet, but is displayed on another.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Bcoon, 2019-03-23
@Volunteer

=ARRAYFOMULA(SUM((ISOWEEKNUM(DATEVALUE('Database'!C1:C100))=ISOWEEKNUM(TODAY()))*('Database'!L1:L100="status2"))
) entire columns. You need to specify which lines to count.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question