Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 7th 16, 08:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2016
Posts: 1
Default 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

I am using Countif to see how many people that attended one time got A's and that worked as =COUNTIFS(C36:C65,"1",B36:B65,"a")

And when it came to attendance of 10+, that worked as =countifs(C36:C65,"9",B36:B65,"a")

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.

In the C column, there is the amount of times each person attended and the column b is the grade they got. How can you use COUNTIFS for more ranges to count?

  #2   Report Post  
Old July 7th 16, 08:24 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,853
Default 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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I count a range of times and link it another worksheet. Jay C Excel Discussion (Misc queries) 3 May 20th 09 03:14 PM
Countifs -Count no of times products have been sold on particular kje.1953 Excel Worksheet Functions 4 November 20th 08 08:39 AM
Need to Count the number of times a value occurs within a dt range Gina[_2_] Excel Worksheet Functions 9 July 4th 08 10:19 PM
Count times that are more than 5 minutes in a range from a newworksheet Lenchik Excel Worksheet Functions 1 May 20th 08 05:57 PM
Count how many times a certain value is in a certain range [email protected] Excel Discussion (Misc queries) 1 September 5th 06 10:42 PM


All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017