Help with COUNTA formula

[Randy]

Hello, I have a formula I am trying to work with that has a COUNTA sequence
in the formula. The formula works great with the exception of the COUNTA
part. I think I might be missing something. Here is what I have:

=IF('Commission Pool'!$L$2=TRUE, "8 @ "& 'Commission Level'!$I$18 & " / "&
COUNTA(D2283)) " @ "& 'Commission Level'!$K$18, 'Commission Level'!$I$15)

Any ideas or suggestions would be great appreciated.

Thanks in advance,

 

[Randy]

lol...never mind...I'm a dork! I figured it out. Thanks for looking.

 

[T. Valko]

Try it like this...

Plug in the sheet name

All on one line

=IF(L$2=TRUE,"8 @ "&I18&" / "
&COUNTA(D2283)&" @ "
&K18,I15)