LinkBack URL
About LinkBacks
you cant use whole column references pre excel 2007 shorten it a bit to
=SUMPRODUCT(('all information'!G1:G1000<=VALUE("06:00"))*('all information'!B1:B1000="White"))
you cant use whole column references pre excel 2007 shorten it a bit to
=SUMPRODUCT(('all information'!G1:G1000<=VALUE("06:00"))*('all information'!B1:B1000="White"))
Last edited by martindwilson; 11-06-2012 at 10:01 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you very much! It's now returning the value of 0 which is strange ;/ But thank you very much for that pointer, I shall keep it in mind xxx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks