View Single Post
 
Old 12-05-2011, 08:40 AM
twolfend twolfend is offline Windows XP Office XP
Novice
 
Join Date: Dec 2011
Posts: 1
twolfend is on a distinguished road
Default Tricky IF formula

I'm trying to make cells display blank provided a certain field has no value. If the field does have a value, I need the displayed value to be a sum formula. Can't figure it with a sumif formula though... Help appreciated.

ie:
if c20<1, then display nothing, if true display sum(d7:d9)

So frustrating I've spent an hour trying it!

Thanks
Reply With Quote