COUNTIFS is a new function available in Excel 2007. This has proved to be very helpful and it is always a problem if you switch back and forth between the two versions. Well, here is an equivalent for COUNTIFS that you can use until your company decides to spend those extra bucks and get everyone on to version 2007 :)
Let’s assume the data is as below.
These will be the equivalents in 2003, using SUMPRODUCT.
Where E5 has the counter and F5 has the sales-person. The same can be extended for a SUMIFS as below.
Next post, we’ll talk about two functions that are not in any version of Excel yet – MAXIF and MINIF.