S
salvatore
Apologies if this is a well worn topic, and plenty of anticipatory
'thank you's'.
Two columns worth of data: column A has either an S or a C, and column B
has a number between zero and one:
s 1
s .5
c 0
c 1
Id like to only count the number of "c" iterations in column A where the
corresponding B column is greater than zero. In the above sample the
output would be 1.
Pseudo-code:
if a1 = "C" and b1 > 0 then count, else skip
if a2 = "C" and b2 > 0 then count, else skip
if a3 = "C" and b3 > 0 then count, else skip
This is probably one of those answers that stare right in my face, but
she's too hot and im pretending not to stare.
Function gurus unite.
'thank you's'.
Two columns worth of data: column A has either an S or a C, and column B
has a number between zero and one:
s 1
s .5
c 0
c 1
Id like to only count the number of "c" iterations in column A where the
corresponding B column is greater than zero. In the above sample the
output would be 1.
Pseudo-code:
if a1 = "C" and b1 > 0 then count, else skip
if a2 = "C" and b2 > 0 then count, else skip
if a3 = "C" and b3 > 0 then count, else skip
This is probably one of those answers that stare right in my face, but
she's too hot and im pretending not to stare.
Function gurus unite.