I could not find help on this one. I have the spreadsheet below that I want
to do this: Count the number of times that an SC1 has Rev between 250 and
550. Then I would also like to sum up (in a different column) the rev for the
same criteria. This should be easy with sumproduct but I cannot get it done.
Any help?

Name Division Rev
Tom SC1 0
fish SC3 0
roger SC2 300
steve SC2 900
cindy SC1 650
kim SC1 1100
ryan SC3 210
bill SC1 1200
tony SC1 400
ted SC2 200