Hello all,
I have 2 problems:
1. I have the following:
Age:
A1:65
A2:89
A3:70
A4:71
I want to be able to find the number of ages for certain critera, ie:
<60
Between 60-70
Between 70-75
>75
2.I have a list of dates, and I want to be able to count the number of Mondays, Tues, Wed, etc.
Any help would be greatly appreciated.
Hi,
Counting within each criteria will be along these lines:
=COUNTIF(A1:A4,"<60")
=COUNTIF(A1:A4,">=60")-COUNTIF(A1:A4,"<=71")
=COUNTIF(A1:A4,">=70")-COUNTIF(A1:A4,"<=75")
=COUNTIF(A1:A4,">75")
However, you have specified overlapping ranges, so you'll need to adjust these formula as required.
To count the weekdays, you can use these array formulas (CTRL, SHIFT and ENTER to confirm)
Sundays=COUNT(IF(WEEKDAY(G1:G17)=1,1,""))
Mondays=COUNT(IF(WEEKDAY(G1:G17)=2,1,""))
Tuesdays=COUNT(IF(WEEKDAY(G1:G17)=3,1,""))
Wednesdays=COUNT(IF(WEEKDAY(G1:G17)=4,1,""))
Thursdays=COUNT(IF(WEEKDAY(G1:G17)=5,1,"")) etc
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thanks,
Is there a way to do this, and make the critera variable - ie instead of putting it in the formula, it's based on the contents of a cell, which contains the required parameters?
Yes,
For example,
=COUNTIF(A1:A4,B1)
where B1 contains <=71
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks