View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
corne_mo[_2_] corne_mo[_2_] is offline
external usenet poster
 
Posts: 5
Default Sum.If function but depending on 3 different columns?

I hope someone can help me out he
I have 2 worksheets:
WS1
WS2

On WS2 I need to sum all values of column D on WS1 that have:
WS1 column A = 1
WS1 column B = 3
WS1 column C <= 7

Is this possible and if yes, how can I accomplish this?

Thanks in advance.