View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default if with or condition

Hi TM,
I didn't know you could give multiple criteria to SUMIF (and COUNTIF, I
discovered). XL seems to deal with your formula as an array formula, but
doesn't need to be array entered.
Always learning.
Regards - Dave.