Email address obfuscation in effect -- please
click here to turn it off.
[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
- To: MLUG discussion <EMAIL:PROTECTED>
- Subject: [MLUG - DISCUSSION] Excel tricks
- From: Mike Miller <EMAIL:PROTECTED>
- Date: Thu, 8 Nov 2007 11:58:57 -0600 (CST)
- Delivery-date: Thu, 08 Nov 2007 11:59:08 -0600
- Envelope-to: EMAIL:PROTECTED
- Reply-to: MLUG Off-Topic Discussion <EMAIL:PROTECTED>
- Sender: EMAIL:PROTECTED
I want to do this in Microsoft Excel but I'll also want to do it in Calc
(Open Office), so feel free to tell me the answer in Calc terms, if you
happen to know the answer and are willing to share.
I want to use a value in a cell to determine a range for a function. I
thought I used to do this in Lotus 1-2-3 20 years ago, but I'm not sure.
So I think it is doable. For example, I might want to sum the values in
column B from row 1 to row 'X' where X equals the value in cell A1. Any
ideas?
Mike
_______________________________________________
discussion mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/discussion
Home | FAQ | Server | Presentations | Mailing Lists/Archives | Member Tools | Links | Sponsors | Contact