Hi Bob

Thanks for that.
However, I am confused (nothing new there!!).
Normally I use the "*" in the SUMPRODUCT formula and would normally have
submitted
=SUMPRODUCT(--(A2:A100="Closed")*(B2:B100="Settings"))
which works fine.

However, following a post from J.E. the other day where he suggested the use
of the "," as a separator was marginally more efficient, I substituted it in
this formula (without testing) and you quite rightly pointed out it doesn't
work.

Perhaps I need more explanation on the difference between the two methods.

--
Regards
Roger Govier
"Bob Phillips" wrote in message
...
typo

=SUMPRODUCT(--(A2:A100="Closed"),--(B2:B100="Settings"))

--
HTH

Bob Phillips

"Roger Govier" wrote in message
...
One way would be
=SUMPRODUCT(--(A2:A100="Closed"),(B2:B100="Settings"))
Change ranges to suit

--
Regards
Roger Govier
"kiranmani" wrote in message
...
Coloum A Column B
Closed Settings
Open Settings
Closed Prametes
Open UI

I want to calculate Number of rows which have in Column A Closed and in
Column B Settings . Please help ..