How to count COl3 with criteria in COl 1
 

I need to check for a value in column 1, and if true, count the value in the
same row in column 3.

Is it possible or feasible with Countif, or should I loop through the array
and set a counter etc.

Thanks

How to count COl3 with criteria in COl 1
 

Bobby

look at SUMIF rather than COUNTIF

Regards

Trevor


"Bobby" wrote in message
...
I need to check for a value in column 1, and if true, count the value in
the
same row in column 3.

Is it possible or feasible with Countif, or should I loop through the
array
and set a counter etc.

Thanks

How to count COl3 with criteria in COl 1
 

I thought that SUmif couldn't be made to simply count. I need to count
ocurrances , not sum them up. I can devide the sum by number oof occurances
since I don't know how namy there will be and also, the numbers vary wildly.


"Trevor Shuttleworth" wrote:

Bobby

look at SUMIF rather than COUNTIF

Regards

Trevor


"Bobby" wrote in message
...
I need to check for a value in column 1, and if true, count the value in
the
same row in column 3.

Is it possible or feasible with Countif, or should I loop through the
array
and set a counter etc.

Thanks

How to count COl3 with criteria in COl 1
 

=SUMIF(A:A,val,C:C)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bobby" wrote in message
...
I need to check for a value in column 1, and if true, count the value in
the
same row in column 3.

Is it possible or feasible with Countif, or should I loop through the
array
and set a counter etc.

Thanks

How to count COl3 with criteria in COl 1
 

You can use SUMPRODUCT to count values in column C, where there is a
value in the same row in column A:

=SUMPRODUCT(--(A1:A17<""),--(C1:C17<""))

Bobby wrote:
I need to check for a value in column 1, and if true, count the value in the
same row in column 3.

Is it possible or feasible with Countif, or should I loop through the array
and set a counter etc.

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

How to count COl3 with criteria in COl 1
 

You said count the value, that is why Trevor suggested SUMIF. I thought the
same thing. Also, if you want to count them, which will you count, the
number in column A or column CO. Your requirement doesn't make sense to me.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bobby" wrote in message
...
I thought that SUmif couldn't be made to simply count. I need to count
ocurrances , not sum them up. I can devide the sum by number oof
occurances
since I don't know how namy there will be and also, the numbers vary
wildly.


"Trevor Shuttleworth" wrote:

Bobby

look at SUMIF rather than COUNTIF

Regards

Trevor


"Bobby" wrote in message
...
I need to check for a value in column 1, and if true, count the value
in
the
same row in column 3.

Is it possible or feasible with Countif, or should I loop through the
array
and set a counter etc.

Thanks