Must be urgent for you to post everywhere.

--
Don Guillett
SalesAid Software

"preety" wrote in message
...

Hi, This is URGENT.

Problem: In MS Excel, Column A contains values from A to Z and Column B
contains value from 1 to 5. Now, I need to count the records that have
"A" has value in Column A and "3" in Column B. I had tried with COUNTIF
function but it works only for one criteria, i.e. it can be used if I
want to count the records with value "A" in Column A or the records
with "5 in Column B. Is there any function that can be used for this
purpose.
Pls treat this very urgent.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/