Hi,

You may also try the following:

=sum(if((range3="v")*(range2="in"),sum_range))

Please press Ctrl+Shift+Enter after the formula.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Christy" wrote in message
...
This is what I have:
Col G Col H Col I
15 in v
20 ot v
30 in n
This is what I need to do:
When I13:I36 = v AND H13:H36 = in, THEN add G13:G36
Thanks for your help
Christy