Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif function
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use countif function | Excel Worksheet Functions | |||
countif function | Excel Worksheet Functions | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions |