Thread
:
I'm trying to use COUNTIFS to count how many times someone attendedtutoring, but in a data range such as 4-9 or 2-3
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
I'm trying to use COUNTIFS to count how many times someone attended tutoring, but in a data range such as 4-9 or 2-3
Hi,
Am Thu, 7 Jul 2016 12:11:29 -0700 (PDT) schrieb
:
My problem is two other data sets that require multiple countif ranges.
2-3 attendance and 4-9. I would think it would be something like 1 and <4 for the 2-3 and 3 and <10 for the 4-9, but I've tried so many things for it to count those.
for 4-9 try:
=COUNTIFS(C36:C65,"3",C36:C65,"<10",B36:B65,"a")
Regards
Claus B.
--
Windows10
Office 2016
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch