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
 

Thread Tools
Display Modes


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 08:00 AM.


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