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?