I don't know. Do you have an alternative for a formula? I need to look at
Columns A&E and if both meet the criteria, I need to add Column B (ONLY the
criteria that meets).
--
Thank you for your help
MO
Albany, NY


"Kigol" wrote:

Does the order of columns matter in SUMPRODUCT as it does in LOOKUP
functions? ie: If I had data in Column J to sum, but the two criterion
were in columns K and M, would if affect the outcome at all?