Help with COUNTA formula
Try it like this...
Plug in the sheet name
All on one line
=IF(L$2=TRUE,"8 @ "&I18&" / "
&COUNTA(D22:D83)&" @ "
&K18,I15)
--
Biff
Microsoft Excel MVP
"Randy" wrote in message
...
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,
--
Randy Street
Rancho Cucamonga, CA
|