Help with COUNTA formula

R

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(D22:D83)) " @ "& 'Commission Level'!$K$18, 'Commission Level'!$I$15)

Any ideas or suggestions would be great appreciated.

Thanks in advance,
 
T

T. Valko

Try it like this...

Plug in the sheet name

All on one line

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array formula - help with #NUM! errors 0
Vb Assistance 1
CountA 2
Please help me with a formula 4
Help with a formula 2
Help with a formula: Tammy 1
Match Formula 4
Help excluding some info from counta formula 4

Top