still learning to count
Posted by ed on March 28, 2001 6:15 AM
ok, i've tried everything suggested (See msg "counting with multiple criteria" below) but none of the suggestions are working. maybe i'm not explaining this as well as i should ..
in column J i have, among others, the name Tim. in column K i have either blank cells or the word Terminated. how can i count how many times they happen side by side? i'm beginning to think that you can't have more than one criteria for the COUNT or COUNTIF function. please tell me i'm wrong.
then, i have to count how many times Tim occurs in J with a blank cell beside it in K.
and THEN, i have to sum the numeric values in G when each of the 2 scenarios above occur. but i think i can figure this one out once the first/counting problem is solved.
sorry if this is getting old. i plan to give up after today if i can't get it to work. and thanks in advance for any time/energy spent on my stupid dilemma. :)