View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Venkatesan Venkatesan is offline
external usenet poster
 
Posts: 1
Default Sumproduct with conditions - urgent help needed


Hope this works

=if(sum(F8:F13)=xyz,sum(F8:F13),(Sum(F8:F13,I8:I13 )))
Thanks
Venkatesan