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
|