Re: A follow up Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

OK,

Figured it myself in the end. If anyone's interested, my range names
included the column title - so Mike was spot on.

Cheers,
Andrew

"Andrew Mackenzie" <a_d_mackenzie@xxxxxxxxxxx> wrote in message
news:OBUJhEMSJHA.1144@xxxxxxxxxxxxxxxxxxxxxxx
Thanks Mike,

But I have done as you suggested with ISNUMBER and all are true. I have
also double checked that the range names are correct and, for good order,
removed the unnecessary + sign.

Any other ideas please - this is beginning to drive me nuts!

Cheers
Andrew

.
"Mike H" <MikeH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6B3AE59E-D0F1-4E48-9BD9-66E9B9547192@xxxxxxxxxxxxxxxx
Hi,

With the exception of the unnecessary + sign the formula is fine and
should
read.



=SUMPRODUCT((dciValueDate<=$L$64)*(dciValueDate>=(EOMONTH($L$64,-1)+1))*(dci
GBPAmount))

If yoyur getting a Value error then either L64 or the range you are
summing
aren't a date and or numbers.

Try this
=isnumber(L64) should evaluate as true and likewise for the sumrange.

Mike

"Andrew Mackenzie" wrote:

I have now tried to incorporate the "BOMONTH" formula into the larger
formula below but I am getting #VALUE.



=SUMPRODUCT((dciValueDate<=+$L$64)*(dciValueDate>=(EOMONTH($L$64,-1)+1))*(dc
iGBPAmount))

The formula is attempting to sum the amounts in the range dciGBPAmount
where
the date in the column dciValueDate is in March 2008. L64 contains
the
date
31st March 2008.


Any ideas what is wrong with the syntax?

Cheers,

Andrew







.

Relevant Pages

  • Re: 8 in 10 want tighter immigration controls.
    ... playing "spot the white child" ... What's England like Bod? ... What's India like, Mike? ...
    (uk.legal)
  • Re: Why do you wear a vest?
    ... Funny that you should bring that up, ... Wishing you even a dime size spot of skin graft would be unsporting. ... That was witty reply, Mike! ...
    (rec.motorcycles)
  • Daag, now THIS is what I call "pollution"
    ... What if people started responding to the eyefuck posts from mike ... ---are you asking 'how much distance from the spot' am i gonna argue ... DECIDING if the disc is being put into play at the right place. ... because that ground tap is dumb as hell and useless. ...
    (rec.sport.disc)
  • Re: 8 in 10 want tighter immigration controls.
    ... It's a question of 'spot the white child'... ... What's England like Bod? ... What's India like, Mike? ...
    (uk.legal)
  • Re: 1898 Victoria Sovereign
    ... head and a George V) at spot (+ship) in AU & MS respectively, ... Hi Mike, I'll keep you in mind for my next buy, couple of weeks if all ...
    (rec.collecting.coins)