CODEWITHSUNDEEP
excelcountif
SamC
SamC

Reputation: 47

Excel: counting content between dates

I'd like to count cells that contain "/" or "\" that are less than a date I set.

To check / and \ I have:

=COUNTIF('Attendance Data'!7:7,"/")+COUNTIF('Attendance Data'!7:7,"\")

To check dates I have:

=COUNTIF('Attendance Data'!2:2,"<"&D3) D3 is the date I set.

How does one combine these into an AND statement?

i.e. Only count cells that contain / or \ and are older than said date.

Thanx for looking, Sam

Upvotes: 0

Views: 34

Answers (1)

Lutz
Lutz

Reputation: 655

you could use countifs

=COUNTIFS('Attendance Data'!7:7,"/",'Attendance Data'!2:2,"<"&D3)+COUNTIFS('Attendance Data'!7:7,"\",'Attendance Data'!2:2,"<"&D3)

Upvotes: 1

Related Questions