Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-05-2011, 08:40 AM
twolfend twolfend is offline Tricky IF formula Windows XP Tricky IF formula Office XP
Novice
Tricky IF formula
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Tricky IF formula Tricky Word problems Eva Word 3 10-14-2011 03:18 AM
Tricky "random word" Question!! seba1685 PowerPoint 0 04-21-2011 12:17 AM
Tricky IF formula Help with formula please. AndrewSE Excel 3 04-05-2011 08:50 PM
Tricky IF formula PMT Formula OneOleGuy Excel 4 03-05-2011 09:54 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft