Hi, This is URGENT.

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

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