View Single Post
  #10   Report Post  
kras
 
Posts: n/a
Default =SUMIF(Rewards!$AH$3:$BI$3, "Targets!O30:<O31", Rewards!$AH$20:$BI$20)


Hi Dave,

I didn't manage to do it. I attached an excel file with the example
table and the formula you provided.


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4036 |
+-------------------------------------------------------------------+

--
kras
------------------------------------------------------------------------
kras's Profile: http://www.excelforum.com/member.php...o&userid=28667
View this thread: http://www.excelforum.com/showthread...hreadid=483373