Michael

Something like
=if(and(a1=37,f1="VD"),sum(g:g),0)

However, your description is a bit vague. Do you want the sum of column A to be 37 and what is the VD that is in column F?

Perhaps an example file to clarify the the above doesn't solve your request.

rylo