Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counta formula | Excel Discussion (Misc queries) | |||
counta formula | Excel Discussion (Misc queries) | |||
Formula for Counta | Excel Worksheet Functions | |||
Counta formula | Excel Discussion (Misc queries) | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |