Double IF Formula?

Hi,
I'd like to achieve the following:

IF COLUMN A = 37 AND COLUMN F = VD, SUM COLUMN G.

How would i do this?

Thanks
Michael

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

Hi,
Please see attached.

Sorry if i didn't make myself very clear,
If column A says 37, and the the F column says VD, then the cost figure in column G should be added up.

Hopefully this is more clear?

Thanks
Michael

Please note that the attached example is only a small sample of the spreadsheet. There are hundreds of rows in the actual document..

That works great.
Thanks a lot!

Michael