Excel help

  DrScott 18:39 28 Jan 2007
Locked

Just a question for the Excel experts round here (VoG!!):

I've created a spreadsheet and a summary form for that spread sheet made up of lots of functions extracting data from the spreadsheet. What I want to do now is to have way by which a person can type in a start date and end date, and the summary functions then only execute on spreadsheet cells that are between those two dates.

I guess what I mean is that I want to define the range in which the functions extract the necessary data by the use of dates, which can be altered at will.

Does that make any sense?! Any help will be very very gratefully received :)

  lotvic 19:45 28 Jan 2007

have a look on click here
load of stuff in the 'Office Help' section

  VoG II 15:56 01 Feb 2007

See click here - is this the sort of thing.

I have no idea whether it worked as no feedback.

  DrScott 18:03 01 Feb 2007

but I sought help elsewhere and found the answers here: click here

semper_si being my handle

Using a series of sumproduct functions seemed to be the key.

  VoG II 18:11 01 Feb 2007

Yes, and you did well to use -- rather than * to coerce the values from Boolean to integer. For an explanation see the explanations from Aladin Akyurek
Aladin Akyurek


I would have replied sooner but I have been under the care of a local hospital for a dislocated and badly broken ankle. I'll never get through airport security again with the amount of pins and plates that I'm now carrying. Not that I'm in a fit state to leave the house, let alone fly!

  VoG II 18:11 01 Feb 2007

OOps! Link click here

  DrScott 18:16 01 Feb 2007

I'm very sorry to hear that VoG :(

Fracture dislocations of the ankle are tricky things to fix, and yes, lots of pins, plates and screws.

I hope you recover quickly and get hobbling then walking soon :)

Thanks for the link!

  Chris the Ancient 18:34 01 Feb 2007

See what happens when you lose it and end up kicking the desk!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?