Thread: Awkward sumif/sumproduct with three criteria over two ranges
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Awkward sumif/sumproduct with three criteria over two ranges
Something like this should work:
=SUMPRODUCT((B2:B4="x")*((C2:C4="y")+(C2:C4="z")), A2:A4)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"PBcorn" wrote:
need to sumif or sumproduct based on text values in two columns:
sum values in sumrange if col1 value= "x" AND col2 value = ("y" OR "z")

Reply With QuoteReply With Quote