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.
Last replyBest Answer
More aboutexcel formula
pseudocode: If text in F1 = values in Col A AND text in F2 = values in Col C, count.