Excel help

  DrScott 18:39 28 Jan 07
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 07

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

  VoG II 15:56 01 Feb 07

See click here - is this the sort of thing.

I have no idea whether it worked as no feedback.

  DrScott 18:03 01 Feb 07

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 07

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 07

OOps! Link click here

  DrScott 18:16 01 Feb 07

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 07

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

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

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos