Any body out there smart enough???

try COUNTA

CountA is only part of the formla??????

"JR573PUTT" <JR573PUTT.23aa8n_1140028801.5666@excelforum-nospam.com> wrote
in message news:JR573PUTT.23aa8n_1140028801.5666@excelforum-nospam.com...
>
> CountA is only part of the formla??????

Maybe he thought you were SMART ENOUGH to use the Insert Formula menu
command, and notice that it offers rather clear help for how to use whatever
formula you choose from the pick list that's right in front of you. Maybe.

Sorry good one, but suffice to say I be smart enough to do that, but the formula want work, are you smart enough to write down the right formula?

"JR573PUTT" <JR573PUTT.23abmq_1140030603.9411@excelforum-nospam.com> wrote
in message news:JR573PUTT.23abmq_1140030603.9411@excelforum-nospam.com...
>
> Sorry good one, but suffice to say I be smart enough to do that, but the
> formula want work, are you smart enough to write down the right formula?

I already have too many apps running, none of which can be shut down at the
moment. If I start Excel, the whole house of cards will fall. So, use
Insert, Formula, choose the formula or function you want to use, and the
next dialog box (if I recall) will show you very clearly how to use the
formula. If not, the Excel help system may contain further illustrations.

Another way:

=SUMPRODUCT(('detail sheet'!$A$1:$A$10=331)*('detail sheet'!$B$1:$B$10<>""))



HTH

Jean-Guy