Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF
Hi
I would put the category require form column A in say cell C1, and the month required in B1. Assuming your dates are Text e.g. "Jan", "Feb" etc. then =SUMPRODUCT(--($A$1:$A$100=C1),--($B$1:$B$100=D1)) If the dates are Excel dates, e.g. 01/01/2006, but formatted to show Jan, Feb etc., then with an Excel date in D1 =SUMPRODUCT(--($A$1:$A$100=C1),--(MONTH($B$1:$B$100)=MONTH(D1))) -- Regards Roger Govier "SkyGanz" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF
Hi
Try something like this: =SUMPRODUCT((A2:A1000="direct mail")*(B2:B1000="January")) Hope this helps. Andy. "SkyGanz" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |