Different data in multiple cells

[bluewaternavy]

Hi, I am very new to using excel. I am trying to do a search (total) of the number of times M9 responded to Zone 5-U. Here is formula I came up with, but it coming back with errors. I over 36,000 calls to test, so this is just an example of course.

=COUNTIFS(N3:N32216,"M9",O3:O3221668,"5-U")
The "N's & O's" are the columns where the data is actually in the spreadsheet.

M822 <colgroup><col></colgroup><tbody> </tbody>	9-U
M9	5-U
M8 <colgroup><col></colgroup><tbody> </tbody>	8-U
M15	15-R
M5	5-U
M9	5-U
M4	4-U
M9	5-U
M715	9-U
M205	5-U
M215	5-U

<tbody>
</tbody>

Thanks for the help in advance.

---

---

 

[circledchicken]

Hi,

It might be best to ask this new question as a new thread so more people might look at it.
Also, it will be easier if you provide a small sample of data with expected outcomes.

 

[bluewaternavy]

Thanks. I got this solved, but would please take a look at a thread that I posted earlier? http://www.mrexcel.com/forum/excel-questions/756318-date-time-calculation.html

Thanks