View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default sumif with 2 criteria?

Hi

If you are using xl2007, you can use =Sumifs() function, else you have to
use a SumProduct formula.

Supply us with some more information if you need help writing the formula.

Regards,
Per

"Wombat" skrev i meddelelsen
...
I want to add up some turnover stats in column E but sort the numbers
according to two criteria held in columns A and D

If there was only the one I would do this with a simple sumif formula but
I'm not too sure how to go about it with two separate criteria...

Any help? :-)