A VLOOKUP formula returns one value from a table, so it wouldn't sum or
count the values.

Another option is to use SUMPRODUCT, as described he

http://www.contextures.com/xlFunctio...tml#SumProduct

substituting cell references for the typed values.

kreatiff wrote:
Thanks to both of you to responding to my plea for help...

Shouldn't I be using VLOOKUP ? and is it possible to SUM or COUNT using
VLOOKUP ?

-----------

I'll have a close look at your suggestions :-)




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html