Countifs logic or other count logic

[Lokoloko]

How can i count the updated data. Please help

The yellow cell is where im gonna input my formula, i've try the "countifs" but it fails when it comes to criteria_range

Here's what i try so far:

Option 1
=countifs(d7&d9,">""",d7&d9,"<>Not Updated") and it didnt work

Option 2
=countifs(d7:d9,">""",d7:d9,"<>Not Updated") this method works but the data 2 of Program 1 will also be included

Thank you for sharing ideas in advance

 

[6StringJazzer]

The "&" operator is text concatenation. It does not mean "this cell and that cell." COUNTIFS does not deal with discontiguous ranges. One straightforward way to do this:

=AND(D7<>"",D7<>"Not Updated")+AND(D9<>"",D9<>"Not Updated")

 

[Alex Blakenburg]

I think I might be reading this slightly differently to Jeff. How representative is your data ?
Is Data 1 in all 3 places just a place holder or do they match ?
Why did you opt to look for "Not Updated" as opposed to looking for "Updated" are there more categories that fall under Updated ?

Based on your sample data this should work.

20231031 Countifs Lokoloko.xlsx
	A	B	C	D	E	F
1
2		Category		Day 1	Day 2
3		Update	Data 1	1	1
4			Data 2	1	2
5
6
7		Program 1	Data 1	Updated	Not Updated
8			Data 2	Not Updated	Updated
9		Program 2	Data 1	Not Updated	Updated
10			Data 2	Updated	Updated
11
Sheet1

Cell Formulas
Range	Formula
D3:E4	D3	=COUNTIFS($C$7:$C$10,$C3,D$7:D$10,"Updated")

 

[6StringJazzer]

Here is another (better) way based on my first interpretation

=COUNTIFS(D7:D10,"<>",D7:D10,"<>Not Updated",C7:C10,"Data 1")

 

[Lokoloko]

I think I might be reading this slightly differently to Jeff. How representative is your data ?
Is Data 1 in all 3 places just a place holder or do they match ?
Why did you opt to look for "Not Updated" as opposed to looking for "Updated" are there more categories that fall under Updated ?

Based on your sample data this should work.

20231031 Countifs Lokoloko.xlsx
	A	B	C	D	E	F
1
2		Category		Day 1	Day 2
3		Update	Data 1	1	1
4			Data 2	1	2
5
6
7		Program 1	Data 1	Updated	Not Updated
8			Data 2	Not Updated	Updated
9		Program 2	Data 1	Not Updated	Updated
10			Data 2	Updated	Updated
11
Sheet1

Cell Formulas
Range	Formula
D3:E4	D3	=COUNTIFS($C$7:$C$10,$C3,D$7:D$10,"Updated")

Im gonnay try this one, thnk you sir.