Conditional sum

[k1n6]

Hi Forum,

I'm new here please forgive if I've over looked any netiquettes.

I have two columns of numbers, we'll call them priceone and pricetwo

All rows have priceone, only a few have pricetwo.

I want to sum the pricetwo's, but when pricetwo is blank, just use the value from the priceone column for that row.

Suggestions or tips? thanks.

[MarvinP]

Hi k1n6 and welcome to the forum,

I think the SumIf() function does the trick. See the attached.

[k1n6]

Thanks that was spot on, I threw some reputation your way.