Thread: Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Help

Hi, try this

=somarproduto(--(Time!b2:b2="F-10 CWE")*(Time!C2:C20="L-02
SICK")*(TIME!L2:L20))

hth
regards from Brazil
Marcelo


"Fnipp" escreveu:

This function adds everything in the column L2:L20. I only want to add if
the both conditions are met and if not then do not add the amount.

=SUM(IF(Time!B2:B20="F-10 CWE",IF(Time!C2:C20="L-02 SICK",Time!L2:L20)))

thanks,