Help with COUNTA formula
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 |
Help with COUNTA formula
lol...never mind...I'm a dork! I figured it out. Thanks for looking.
-- Randy Street Rancho Cucamonga, CA "Randy" wrote: 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 |
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 |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com