Prev: right click
Next: scroll left and right mouse wheel doesn't work in excel
From: doberman on 3 Apr 2010 08:13
I am trying to read data based on the date criteria so that I can collate
data as it is entered. Can I add TODAY() within a SUMIF formula if so how?

From: Bob Phillips on 3 Apr 2010 08:53
You mean like this

=SUMIF(A:A,TODAY(),B:B)

--

HTH

Bob

"doberman" <doberman(a)discussions.microsoft.com> wrote in message
news:56D99E77-D078-41F0-80C9-94CAC9AC057F(a)microsoft.com...
>I am trying to read data based on the date criteria so that I can collate
> data as it is entered. Can I add TODAY() within a SUMIF formula if so how?
>


 | 
Pages: 1
Prev: right click
Next: scroll left and right mouse wheel doesn't work in excel