Hi all,
Looking for some input from a Excel guru much smarter than i. I'm wrestling with a SUMPRODUCT formula to count matching entries on multiple criteria. I'm still on Excel 2003 so can't use COUNTIFS etc.
To give you an idea what i'm trying to achieve. I started with this...
Hi All
First time poster, long time lurker (great site btw Chandoo). Intermediate at best Excel user, so i'm looking to those more proficient than i am from this excellent site.
Background : Still on Excel 2003 for now. Majority of my dynamic reports typically combine CHOOSE (linked to a...