Thread: Awkward sumif/sumproduct with three criteria over two ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PBcorn PBcorn is offline
external usenet poster
  
Posts: 79
Default Awkward sumif/sumproduct with three criteria over two ranges
need to sumif or sumproduct based on text values in two columns:

so:

sum values in sumrange if col1 value= "x" AND col2 value = ("y" OR "z")

please advise
Reply With QuoteReply With Quote