Excel Formula Help

wanamingo

Distinguished
Jan 21, 2011
48
0
18,580
0
So Im trying to figure out the syntax for this formula but cant seem to get it right.

I have a multi column Spreadsheet, The relevant columns are Column A which has just months (January, February etc) and column C has company names. What the users is looking for is a formula that will look at column A for all the February entries and then look at column C for company. For all the rows that have both February and Acme give a count.

So if there are 3 Februaries and 3 acme it will return 3. Im having troubles running this against entire columns... Any help would be much appreciated.
 
Thread starter Similar threads Forum Replies Date
S Apps General Discussion 5
H Apps General Discussion 13
U Apps General Discussion 1
P Apps General Discussion 1
P Apps General Discussion 4
D Apps General Discussion 2
W Apps General Discussion 2
C Apps General Discussion 7
S Apps General Discussion 3
B Apps General Discussion 4
M Apps General Discussion 11
indyitguy Apps General Discussion 8
E Apps General Discussion 1
GOM3RPLY3R Apps General Discussion 6
Christopher Chung Apps General Discussion 4
S Apps General Discussion 4
G Apps General Discussion 1
E Apps General Discussion 3
A Apps General Discussion 1
R Apps General Discussion 2

ASK THE COMMUNITY