Hope you can help!
On the attached doc, on the summary tab in d13 I have a functioning formula. I'd like to add a criteria that tells it to only return the value if it is greater than zero. If it is NOT greater than zero, I'd like to just have a blank cell.
Any help would be greatly appreciated.
Try in D13:
Drag down and across.
Please Login or Register to view this content.
Quang PT
File / Options / Advanced / Show a zero in cells that have zero value.
This will leave the cells blank when the formula result is zero without the need to alter your current formulas.
BSB
EDIT: You can ignore this. I misread the OP. This approach would still show negative results but would work if the possible values were only zero or greater.
Last edited by BadlySpelledBuoy; 12-26-2014 at 12:53 PM.
In D13, enter =IF(SUMIF(INDIRECT(D$9&"!$C$12:$C$44",1),$B13,INDIRECT(D$9&"!$D$12:$D$44",1))>0,SUMIF(INDIRECT(D$9&"!$C$12:$C$44",1),$B13,INDIRECT(D$9&"!$D$12:$D$44",1)),"") drag it across and down
Perfect! Thank you so much! That formula worked better than I expected!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks