Thread: Really need help with formula(Excel Office 2003)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Really need help with formula(Excel Office 2003)
one way:

=SUM(IF(($A$1=$C$1:$C$4)*($A$1<=$D$1:$D$4),$E$1:$ E$4,))

this is an array-formula so insert it with CTRL+SHIFT+ENTER
Reply With QuoteReply With Quote