View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Wombat Wombat is offline
external usenet poster
 
Posts: 45
Default sumif with 2 criteria?

Thanks for your answers. I think I get the principle of the formula but I get
a #NAME error when I try it...

=sumproduct((C18:C31=a)*(D18:D31=q)*(E18:E31))

My version of Excel (2003 in German!) seems to want semi-colons instead of *
symbols. Does this make a difference?

Advice?