I need to get a value for two sets of criteria. So basically i need a type of countif formula that adheres to two sets of criteria. The formula needs to look at two columns of data - and if the criteria in both is met must be counted.
has anybody got an idea that I could use here?
For multiple criteria counting use SUMPRODUCT, e.g.
=SUMPRODUCT(--(A1:A100="x"),--(B1:B100="y"))
Take a look at this like on SUMPRODUCT
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Fantastic - thanks for the help - works beautifully!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks