Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counif
Does anybody know if I can count the number of "STOPS" in one column fr a particular day of the week in another column. E.g. I want to count how many "STOPS" occur on a "MONDAY" -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=470141 |
#2
|
|||
|
|||
=SUMPRODUCT(--(A2:A20="Monday"),--(B2:B20="STOPS"))
if the days are textual, i.e. not real dates. If they are real dates use =SUMPRODUCT(--(Weekday(A2:A20)=2),--(B2:B20="STOPS")) -- HTH Bob Phillips "moglione1" wrote in message ... Does anybody know if I can count the number of "STOPS" in one column fr a particular day of the week in another column. E.g. I want to count how many "STOPS" occur on a "MONDAY" -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=470141 |
#3
|
|||
|
|||
assuming "STOPS" are in column [A] and days are in column [b] in text
format: =SUMPRODUCT(--(A1:A100="STOP"),--(B1:B100="MONDAY")) Regards, KL "moglione1" wrote in message ... Does anybody know if I can count the number of "STOPS" in one column fr a particular day of the week in another column. E.g. I want to count how many "STOPS" occur on a "MONDAY" -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=470141 |
#4
|
|||
|
|||
This only produces a #num error. AAAAAHHHHHHH!!!!!!!!!!! -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=470141 |
#5
|
|||
|
|||
Sounds like you haven't implemented as shown.
Give some sample data and the formula you used. -- HTH Bob Phillips "moglione1" wrote in message ... This only produces a #num error. AAAAAHHHHHHH!!!!!!!!!!! -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=470141 |
#6
|
|||
|
|||
Do you have #num in your data?
Sometimes, it's good to show the formula you actually tried, too. moglione1 wrote: This only produces a #num error. AAAAAHHHHHHH!!!!!!!!!!! -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=470141 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counif but not all the cells | Excel Worksheet Functions |