Syed Ali Zubair

Posts: n/a

How do I perform a "Countif" function for Two Columns?

I am facing problem that I want to count number of occurances of a set of
text spread in Two Columns. For example, I have two columns A and B. In
Column A, I have values F, B, L...In Column B, I have values F, M, N...Now I
wish to know that how many occurances are there in which the value in Column
A is "F" and Value in Column B, is "M".
I hope I am able to convey my problem effectively. Please help me in this
regard.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
countif function	etan	Excel Worksheet Functions	5	February 7th 05 12:55 AM
Perform functions on the result of adding two columns	Tim Archer	Excel Worksheet Functions	2	February 2nd 05 03:25 PM
Advanced COUNTIF Function	License Boy	Excel Worksheet Functions	3	December 8th 04 02:23 PM
The countif function in Excel 2002.	Lounsbud	Excel Worksheet Functions	1	November 22nd 04 03:19 PM
hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION	Marty	Excel Worksheet Functions	1	November 11th 04 09:45 PM

All times are GMT +1. The time now is 04:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us