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 ..
|