Hi,
What are you trying to do? Find a particular value, or sum (or count) a range of values, given a lot of IF conditions?
It's possible that a SUMIFS() or COUNTIFS() formula (given you have Excel 2010) will be preferable to the old SUMPRODUCT work around that was necessary in earlier versions.
Bookmarks