bluewaternavy
New Member
- Joined
- Feb 7, 2014
- Messages
- 40
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.
<tbody>
</tbody>
Thanks for the help in advance.
=COUNTIFS(N3:N32216,"M9",O3:O3221668,"5-U")
The "N's & O's" are the columns where the data is actually in the spreadsheet.
<colgroup><col></colgroup><tbody> </tbody> | 9-U | |
M9 | 5-U | |
<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.