Dear Domenic
thanks for your suggestion.
i could able to get first part of your advice.
In the 2nd part could you explain a little bit further
I am trying that in a sheet looks like this.
apr may jun ..... cum
prod1 prod2 prod1 prod2 prod1 prod2 prod1 prod2
15 &20 20 20 12 10 3
=count(a1,c1,e1,...)
thanks in advance

"Domenic" wrote:

Assuming that B2 contains 15 & 20, and G2 contains the count formula,
try the following...

1) Select G2

2) Insert Name Define

Name: Result

Refers to:

=EVALUATE("{"&SUBSTITUTE($B2,"&",",")&"}")

3) Enter the following formula in G2...

=COUNT(Result)

To include another range with this count, try...

=COUNT(Result,Range)

Hope this helps!

In article ,
vijaydsk1970 wrote:

i need to post 2 dates in a single cell (eg. 15 & 20) and at the end of that
row there is a count formula covering this cell.
How to post the dates in the single cell, so that the count formula counts 2
dates
there is no scope to post in next cell.
thanks in advance.