Hi people
Is there another formula to use if I wish to have COUNTIFS function but Excel 2003 doesn't allow me to do that?
Thank you.
Hi people
Is there another formula to use if I wish to have COUNTIFS function but Excel 2003 doesn't allow me to do that?
Thank you.
Last edited by westbay; 01-19-2012 at 10:20 AM.
You can use SUMPRODUCT but note that you cannot use entire columns for the range arguments:
=SUMPRODUCT((range1=Criterion1)*(range2=Criterion2))
expanded as required.
Good luck.
Read this article on SUMPRODUCT for more details on the syntax and use of this wonderful function.
http://xldynamic.com/source/xld.SUMPRODUCT.html
Thank you all. I will give it a read.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks