Re: Formula not adding right
- From: "Don Guillett" <dguillett1@xxxxxxxxxxxxx>
- Date: Thu, 7 Sep 2006 08:53:05 -0500
The easiest way is to put a date in a cell and use that cell
=b1
--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Rob" <Rob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:88ECE7B5-42E0-4BD7-AC63-A2DAD141CAE1@xxxxxxxxxxxxxxxx
I'm trying to add up all the items that started on the current day. Johnny
is
the starting point person and the date & time is inserted that he started
an
item is recorded next to his name, currently there should be 11 for just
today. So I figured that i'd tweak a code I got help on yesterday to do
this,
here's what I have...
="Started Today - " &
SUMPRODUCT((B7:B20000="Johnny")*(C7:C20000<=9/7/2006)) & " Total"
The above code returns 8 so I also tried these variants...
="Started Today - " &
SUMPRODUCT((B7:B20000="Johnny")*(C7:C20000<9/7/2006)) & " Total"
="Started Today - " &
SUMPRODUCT((B7:B20000="Johnny")*(C7:C20000>9/7/2006)) & " Total"
="Started Today - " &
SUMPRODUCT((B7:B20000="Johnny")*(C7:C20000<=NOW())) & " Total"
There's more variants but none of them gives me the result I'm looking
for.
Oh, also here's what the date colum looks like, 9/7/2006 9:01:11 AM
Thanks in Advance,
Rob
.
- Prev by Date: Re: Formula not adding right
- Next by Date: Re: Building an address
- Previous by thread: Re: Formula not adding right
- Next by thread: Re: trim "/" from date
- Index(es):
Relevant Pages
|
