Thread: SUMPRODUCT help needed
View Single Post
  #2  
Old 06-12-2005, 10:49 PM
duane duane is offline
Forum Guru
  
Join Date: 11 Jul 2004
Posts: 847
duane is becoming part of the community
sounds like

=SUMPRODUCT((Sheet1!B2:B100="restored")*(Sheet1!C2:C100=Sheet2!A2:A100))

adjust the ranges as required
__________________
not a professional, just trying to assist.....
Reply With Quote