Darren -

Perfect!! Thanks so much.

"Darren Bartrup" wrote:

Have you looked at the SUMIF function?

e.g. =SUMIF(Sheet1!A2:A5,"g",Sheet1!B2:B5) will sum all values in range
B2:B5 on Sheet1 where the corresponding values in range A2:A5 are 'g'.