Lost Value after Day Ends

**eemiller1997** · 07-05-2017, 07:14 AM

I found a flaw in my system!

Because I have this formula set to show nothing if it's not today's date, in order to prevent a million zeros throughout my worksheet before the day arrives, after the day leaves and there is data in the respective column, I'm loosing my value because it reverts to empty when it's not today's date.

How can I modify this formula so if there is data in the respective column (for example, Z6:Z36) and even thought it's not today's date, it leaves the respective value in that cell? The cell in question right now is Z44.

I was thinking this would be the formula, but Excel is not liking it one bit!

Please Login or Register  to view this content.

Thank you for your help.

lost-value.jpg

**JohnTopley** · 07-05-2017, 07:23 AM

Try

=IF(OR(Y$3=TODAY(),COUNTIF(Z6:Z36, ">0")), 450-SUM(Z37:Z43,Z45), "")

**radddogg** · 07-05-2017, 07:25 AM

=if(or(y$3=today(),countif(z6:z36, ">0")),450-sum(z37:z43,z45),"")

**radddogg** · 07-05-2017, 07:26 AM

Ha, you beat me!

**eemiller1997** · 07-05-2017, 03:34 PM

Originally Posted by JohnTopley

Try

=IF(OR(Y$3=TODAY(),COUNTIF(Z6:Z36, ">0")), 450-SUM(Z37:Z43,Z45), "")

Excellent! This worked, thank you

Lost Value after Day Ends

LinkBack

Thread Tools

Rate This Thread

Display

Lost Value after Day Ends

Re: Lost Value after Day Ends

Re: Lost Value after Day Ends

Re: Lost Value after Day Ends

Re: Lost Value after Day Ends

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] if statement for if a num ends in 09

if statement ends with

Lost spaces and Zeros lost when replacing text

[SOLVED] Setting a range that ends where data ends?

+(-)ve values ends in Dr(Cr)

[SOLVED] How do I keep a running total of pounds lost and percentage lost

Bookmarks

Bookmarks

Posting Permissions