"Jim" wrote:
Max, This is perfect!!!

Welcome, good to hear. Please go back and mark that response by pressing the
YES button there (like the one below)

.. how to write this formula so the values are added and not summed?

But adding is the same as summing? If you want to SUM instead of AVERAGE for
the previous multi-criteria scenario ... in another cell, paste the same
expression, then just edit/replace AVERAGE with SUM in the formula bar, then
array-enter the expression as before. That should do it for you. And then
press the YES button below in this response.

P/s: Similarly, if you want to COUNT for the multi-criteria scenario,
replace AVERAGE with COUNT
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---