FAO Mike
Correct Bob, Merseyside.
"Bob Phillips" wrote:
Indeed. David and I are from the UK, I believe Mike H is also from the UK,
Jacob is in India, and Glenn I do not know. So very little if any US input.
--
__________________________________
HTH
Bob
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
You are not "on a United States site". You are in a newsgroup, which is
international.
Some of you may be accessing the newsgroup via various web portals, but
the newsgroup has contributors from many parts of the world, including
those of us in the UK.
--
David Biddulph
Caroline wrote:
Thank you to everyone who responded, my boss is going to be
impressed. Also, just realised that I'm on a United States site, and
I'm in the UK, so if you are all in the States, hello from over the
pond!
Caroline
"Caroline" wrote:
Hi Mike
Sorry to bother you again. Can you see the problem with this
formula? I don't need to pick up a range of codes, I need a
selection of different codes, but from the same data as before.
This is returning zero as the answer. (Sorry it's long, but thought
it was easier to send the whole thing!)
=+SUMPRODUCT((Actuals!A2:A630=5010111)*(Actuals!A2 :A630=5010211)*(Actuals!A2:A630=5120111)*(Actuals! A2:A630=5200111)*(Actuals!A2:A630=5200211)*(Actual s!A2:A630=5260111)*(Actuals!A2:A630=5260211)*(Actu als!A2:A630=5400111)*(Actuals!A2:A630=5400211)*(Ac tuals!A2:A630=5400311)*(Actuals!A2:A630=5401211)*( Actuals!A2:A630=5440111)*(Actuals!A2:A630=5480111) *(Actuals!A2:A630=5640111)*(Actuals!A2:A630=564021 1)*(Actuals!C2:C630))
Thanks again
Caroline
.
|