Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
if val in col3 is one of 13 codes (list), apply factor to val in c | Excel Worksheet Functions | |||
Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Sum Count of Criteria Every 3rd Row | Excel Worksheet Functions |