Home |
Search |
Today's Posts |
#1
|
|||
|
|||
take a look at COUNTIF function in help
"Egon" wrote in message oups.com... I'm having a mess of a time getting this to work. I have an array from a report. I need to count the people in the left column who have a certain value in the right column. I'm doing something wrong, or its monday morning and I can't seem to get it to work. Can anyone help me out here? J. |
#2
|
|||
|
|||
Array Function
I'm having a mess of a time getting this to work.
I have an array from a report. I need to count the people in the left column who have a certain value in the right column. I'm doing something wrong, or its monday morning and I can't seem to get it to work. Can anyone help me out here? J. |
#3
|
|||
|
|||
=COUNTIF(B1:B100,"xxx")
assuming B1:B100 is the right column. -- HTH Bob Phillips "Egon" wrote in message oups.com... I'm having a mess of a time getting this to work. I have an array from a report. I need to count the people in the left column who have a certain value in the right column. I'm doing something wrong, or its monday morning and I can't seem to get it to work. Can anyone help me out here? J. |
#4
|
|||
|
|||
Maybe I didn't explain myself properly.
I have a list of positions in the "A" Column and a list of companies in the "B" column. I need to get the number of positions in the "A" column who's company is equal to a certain company in the B column. CountIF seems to only count within a certain column. Does that explain it better? Thanks J. |
#5
|
|||
|
|||
On 18 Jul 2005 07:09:10 -0700, "Egon" wrote:
Maybe I didn't explain myself properly. I have a list of positions in the "A" Column and a list of companies in the "B" column. I need to get the number of positions in the "A" column who's company is equal to a certain company in the B column. CountIF seems to only count within a certain column. Does that explain it better? Thanks J. =COUNT(IF(A2:A100=[insert criteria],IF(B2:B100=[insert criteria],1,0),0) And confirm with Ctrl+Shift+Enter MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#6
|
|||
|
|||
On 18 Jul 2005 07:09:10 -0700, "Egon" wrote:
Maybe I didn't explain myself properly. I have a list of positions in the "A" Column and a list of companies in the "B" column. I need to get the number of positions in the "A" column who's company is equal to a certain company in the B column. CountIF seems to only count within a certain column. Oops.. make that "SUM" instead of "COUNT" in my answer. Sorry, waking. MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#7
|
|||
|
|||
Thanks a ton, that works flawlessly. That's going to save me massive
amounts of time everyday. Thanks again so much. J. |
#8
|
|||
|
|||
if I may ask, what does the CTRL+SHIFT+Enter do?
I've never seen that before. J. |
#9
|
|||
|
|||
On 18 Jul 2005 08:58:09 -0700, "Egon" wrote:
if I may ask, what does the CTRL+SHIFT+Enter do? I've never seen that before. Also called "CSE formulas", this forces Excel to use the data as an array. Excel will enter the formula as an array and place curly brackets around it to identify it as such. Entering an array by manually including the curly brackets doesn't work, so Ctrl-Shift-Enter must be used. MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
#10
|
|||
|
|||
You can also do it without an array formula
=SUMPRODUCT(--(A2:A100="condition1"),--(B2:B100="condition2")) -- HTH Bob Phillips "Mangus Pyke" wrote in message ... On 18 Jul 2005 08:58:09 -0700, "Egon" wrote: if I may ask, what does the CTRL+SHIFT+Enter do? I've never seen that before. Also called "CSE formulas", this forces Excel to use the data as an array. Excel will enter the formula as an array and place curly brackets around it to identify it as such. Entering an array by manually including the curly brackets doesn't work, so Ctrl-Shift-Enter must be used. MP- -- "Learning is a behavior that results from consequences." B.F. Skinner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Array Function Question | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |