Need help with formula for an intersection count operation

  • Thread starter Thread starter jsatz
  • Start date Start date
J

jsatz

I need help in doing a count on an intersection search

I have the following data as an example
A B
A00003892 Invalid
A00003892 Invalid
A00004591 Invalid
A00004591 Mobile
A00004591 Equipment

I want a generic function I can use in the following kinds of cell
that provides the following counts:

Invalid Mobile Equipment
A00003892 # # #
A00004591 # # #

Basically, I need some function that would count the occurances whe
column A equals "A00004591" AND column B equals "Mobile"

Thanks in advance to anyone who can help..
 
Back
Top