software

I am trying to sum numbers using the NOW() function as my criteria, however
no luck.

sumif($D$1:$BC$1. quot;gt;=NOW()quot;, D2:BC2) Any help would be appreciated.

Thank you

Try this:

Assuming you try to sum D2 to BC2 on your example.

=if($D$1:$BC$1gt;=Now(),sum(D2:BC2),quot;quot;)--
renegan
------------------------------------------------------------------------
renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
View this thread: www.excelforum.com/showthread...hreadid=528713renegan: Thanks for your response, however I got #VALUE! in the cell. Any
suggestions

quot;reneganquot; wrote:

gt;
gt; Try this:
gt;
gt; Assuming you try to sum D2 to BC2 on your example.
gt;
gt; =if($D$1:$BC$1gt;=Now(),sum(D2:BC2),quot;quot;)
gt;
gt;
gt; --
gt; renegan
gt; ------------------------------------------------------------------------
gt; renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
gt; View this thread: www.excelforum.com/showthread...hreadid=528713
gt;
gt;

Here's another variation to try:

=SUM(IF($D$1:$BC$1gt;=Now(),D2:BC2,0))

This is an array formula, so when you have typed it in (and if you
subsequently edit it) use CTRL-SHIFT-ENTER rather than just ENTER - if
you do this correctly then Excel will wrap curly braces { } around the
formula. You should not type these yourself.

You can copy the formula down if you wish.

Hope this helps.

PeteAre you comparing dates and times or just times? If dates and times

=SUMIF(D1:BC1,quot;gt;=quot;amp;NOW(),D2:BC2)

with times only=SUMIF(D1:BC1,quot;gt;=quot;amp;MOD(NOW(),1),D2:BC2)--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Gene Hainesquot; gt; wrote in message
...
gt; renegan: Thanks for your response, however I got #VALUE! in the cell. Any
gt; suggestions
gt;
gt; quot;reneganquot; wrote:
gt;
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; Assuming you try to sum D2 to BC2 on your example.
gt;gt;
gt;gt; =if($D$1:$BC$1gt;=Now(),sum(D2:BC2),quot;quot;)
gt;gt;
gt;gt;
gt;gt; --
gt;gt; renegan
gt;gt; ------------------------------------------------------------------------
gt;gt; renegan's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=10450
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=528713
gt;gt;
gt;gt;

Ok:

$D$1:$BC$1gt;=Now() doesn't work. 2 things you can do:

1- You can use AND($D$1gt;=Now,$E$1gt;=Now,..........,$BC$1gt;=Now) which
won't be pretty
2- Create another row under the row you check the data, check each cell
condition one by one with an if statement and get 1 if true like:
D2=If($D$1gt;=Now,1,0)
Add all the cells with 1 and 0s. If total is less than the number of
columns between D and BC, then you don't add, if it does you do the
sum. Like:
if(Sum(D2:BC2)=52,sum(D2:BC2),quot;quot;)--
renegan
------------------------------------------------------------------------
renegan's Profile: www.excelforum.com/member.php...oamp;userid=10450
View this thread: www.excelforum.com/showthread...hreadid=528713Pete, Peo. Thank you very much..... both formulas worked. U2 renegan 4 ur time

Regards
Gene Haines
quot;Peo Sjoblomquot; wrote:

gt; Are you comparing dates and times or just times? If dates and times
gt;
gt; =SUMIF(D1:BC1,quot;gt;=quot;amp;NOW(),D2:BC2)
gt;
gt; with times only
gt;
gt;
gt; =SUMIF(D1:BC1,quot;gt;=quot;amp;MOD(NOW(),1),D2:BC2)
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;Gene Hainesquot; gt; wrote in message
gt; ...
gt; gt; renegan: Thanks for your response, however I got #VALUE! in the cell. Any
gt; gt; suggestions
gt; gt;
gt; gt; quot;reneganquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; Try this:
gt; gt;gt;
gt; gt;gt; Assuming you try to sum D2 to BC2 on your example.
gt; gt;gt;
gt; gt;gt; =if($D$1:$BC$1gt;=Now(),sum(D2:BC2),quot;quot;)
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; renegan
gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; renegan's Profile:
gt; gt;gt; www.excelforum.com/member.php...oamp;userid=10450
gt; gt;gt; View this thread:
gt; gt;gt; www.excelforum.com/showthread...hreadid=528713
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;