COUNT IF - ExcelBanter

Posted to microsoft.public.excel.worksheet.functions

SkyGanz

Posts: n/a

COUNT IF

I am trying to "count if" across two columns. i.e Column A has categories:
direct mail, ads, tradeshows; and column B has months: January, Feb, Mar.
etc. I need the formula that will show me a count of all "direct mail" in
"January". I can't get the "countif" formula to do it, and a pivot table is
not working either. Any suggestions? Any formulas to try

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
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row	Sam via OfficeKB.com	Excel Worksheet Functions	6	November 29th 05 03:27 PM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	8	May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	0	May 15th 05 08:14 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
SUMPRODUCT Formula to Count Row of data Below Matched Criteria	Sam via OfficeKB.com	Excel Worksheet Functions	8	February 3rd 05 01:37 AM

All times are GMT +1. The time now is 02:43 PM.

Menu

About Us