Combine countif and count statement

[tt.viquel]

is there a way of combining a countif and counta statement e.g.

countif character is A then put the total in column B if not execute the counta statement "...."

does that make sense??

 

[gehusi]

Can you give us some example data, and what the correct output should be?

 

[Scott Huish]

=if(countif(a:a,"a"),countif(a:a,"a"),counta(a:a))

 

[tt.viquel]

Hi,

Thanks for all your responses but i think its something along what HOTPEPPER said. so here is an example of how i want to use it :

=COUNTIF(TABF124!$G:K,"Y")

and

=COUNTA(TABF124!$G:$K)-2

, so if that put value in column A and then counta and put the value in B