One More Formula Question

[doc]

I need to get a specific total from the following criteria. I have data
in 2 columns and need to get a total based upon specific entries in the
cells in thoses columns. For example:

Column A has 4 choices from a picklist. (N,P,C,R)
Column B has a different set of choices. (ENG,OP,T&E,RS)

What I need to do is be able to get an answer for how many N's are also
ENG's

Thanks

 

[Anne Troy]

Try this, Doc:
http://www.officearticles.com/excel/count_using_multiple_criteria_in_microsoft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com

 

[PokerZan]

Sounds like an application for a Pivot Table to me..

 

[PokerZan]

Sounds like an application for a Pivot Table to me...

'Try here for some tips on them...' (
http://www.exceltip.com/excel_tips/Excel_Pivot_Tables/32.html)

 

[Martin P]

=SUMPRODUCT(--(acolumn="n"),--(bcolumn="eng"))
acolumn and bcolumn must have the same dimensions.