# Excel Formula Help

#### wanamingo

##### Distinguished
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.

#### USAFRet

##### Illustrious
Moderator
pseudocode:
If text in F1 = values in Col A AND text in F2 = values in Col C, count.

=COUNTIFS(A:A, F1,C:C, F2). Here, in D8.

In this case, rows 4 & 5.

The range "A:A" looks at the whole of Col A.

#### USAFRet

##### Illustrious
Moderator
pseudocode:
If text in F1 = values in Col A AND text in F2 = values in Col C, count.

=COUNTIFS(A:A, F1,C:C, F2). Here, in D8.

In this case, rows 4 & 5.

The range "A:A" looks at the whole of Col A.

Apps General Discussion 5
Apps General Discussion 13
Apps General Discussion 1
Apps General Discussion 1
Apps General Discussion 4
Apps General Discussion 2
Apps General Discussion 2
Apps General Discussion 7
Apps General Discussion 3
Apps General Discussion 4
Apps General Discussion 11
Apps General Discussion 8
Apps General Discussion 1
Apps General Discussion 6
Apps General Discussion 4
Apps General Discussion 4
Apps General Discussion 1
Apps General Discussion 3
Apps General Discussion 1
Apps General Discussion 2