Only count columns if the column next to it is not blank

G

glotgering

Hello all,

I have a very wide spreadsheet with hundreds of columns and I only wan
to count the column if the column to the left of it is not blank.

My current formula is =COUNTIF(AC69:IV69,"=0") which count any value i
that row as long as it is not blank

Here is an example of what I want to do. Again I only want to coun
columns if the column next to it contains a certain criteria, in thi
case an "x"

1 x 1 1 x 1 Result should = 2 (only colums next to an "x")
x 1 x 1 x 1 x 1 Result should = 4 (count all columns)
1 1 1 1 Result should = 0 (count no columns)

Can this be done
 
B

Bernard Liengme

Could you just count the X's ?
=COUNTIF(AC69:IV60,"x")
Or does your explanation need enlarging?
best wishes
 
G

glotgering

glotgering said:
Hello all,

I have a very wide spreadsheet with hundreds of columns and I only want
to count the column if the column to the left of it is not blank.

My current formula is =COUNTIF(AC69:IV69,"=0") which count any value in
that row as long as it is not blank

Here is an example of what I want to do. Again I only want to count
columns if the column next to it contains a certain criteria, in this
case an "x"

1 x 1 1 x 1 Result should = 2 (only colums next to an "x")
x 1 x 1 x 1 x 1 Result should = 4 (count all columns)
1 1 1 1 Result should = 0 (count no columns)

Can this be done?
Click to expand...

Anyone? Anyone? Bueller?
 
Top