sumproduct with if

[Blake 7]

hi guys - on the back of trying to help someone ive realised that I need to brush up on sumproduct.......

Basically the Criteria is in COL A
the Sum Range is COLS B:F
and the IF is >than 500 and <500

Here the link to the thread.

Any advice warmly recieved!

http://www.excelforum.com/excel-gene...her-table.html

[NBVC]

I supplied one option...

[Blake 7]

Thanks mate