Excel CountIf() or SumIf() with multi criteria 12

[jdegeorge]

Hi

I have a spreadsheet where I want to perform some conditional counting based on the values of 2 different columns.

For example, I have these columns:

[tt]Event Category Type
Dividends Technical Policy
Tax Technical Procedure
Tax New Policy
etc.

I performed CountIf() on CATEGORY and TYPE columns to get the number of times each value appeared (TECHNICAL 2, NEW 1, POLICY 2, PROCEDURE 1). That was the easy part.

What I need is to know the number of times a CATEGORY appears for each TYPE. I tried CountIf and SumIf but I don't know how to include multiple conditions.

CountIf(B1:B3 "Technical" & C1:C3 "Policy&quot or something like this.

Is it possible? There are way too many rows to do this manually! :-(


Jim DeGeorge

 

[hammers1]

Please ignore previous post, sorry wrong page

 

[jdegeorge]

Good. I was going to suggest that you open a whole new post rather than adding your question to my 2-year old one.

Jim DeGeorge

 

[KenWright]

For anyone reading through though, Bob Phillips has done a great job of laying out a web page devoted to Sumproduct, how it works, various examples and also various nuances of it, so well worth bookmarking:-

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------