| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 42359 | 2004-02-09 03:27:00 | Excel Guru's please | flying_green_leprachaun (1767) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 213867 | 2004-02-09 03:27:00 | I was wondering 2 things . 1 . whats a simple way to add all the values in a particular column in multiple worksheets (& find the number that you've added up as well) I want to find the average, but would also like the raw data as well . IE add column E:E in Sheet1, sheet2 . . . sheetN 2 . Any particularly friendly online resources for exel formula's . Forums, databases, that kind of thing . oh . I also would like to learn how to write macro's but thats more for another time no doubt . |
flying_green_leprachaun (1767) | ||
| 213868 | 2004-02-09 04:36:00 | Hi, heres some examples. Sum Column E in Sheet1 to Sheet3 =SUM(Sheet1!E:E,Sheet2!E:E,Sheet3!E:E) Average Column E in Sheet1 to Sheet3 =AVERAGE(Sheet1!E:E,Sheet2!E:E,Sheet3!E:E) Or a simple way to do the same thing if the sheets are consecutive... =SUM(Sheet1:Sheet3!E:E) =AVERAGE(Sheet1:Sheet3!E:E) A good Excel forum is www.mrexcel.com and I would recommend 2 books from John Walkenbach. Excel 2002 Formulas to learn general Excel tips and formulas and Excel 2002 Power Programming With VBA to learn the VBA side of things. Both are probably up to ver 2003 by now and are very good. I bought both together on special via Amazon. |
parry (27) | ||
| 213869 | 2004-02-10 06:24:00 | =COUNTIF(start:end!F:F,"X") this is what I was hoping to do, as I would prefer not counting in each sheet like this =COUNTIF(F:F,"X") & then add all those values together =SUM(start:end!H9) <-- H9 is where the other formula is on each sheet the sheets are sequential (labeled in date order) with a hidden sheet start & end on either side . To allow for a template to use each month that can be easily updated . but it doesnt work . Thanks for the other suggestions though I'll look into them |
flying_green_leprachaun (1767) | ||
| 213870 | 2004-02-10 07:50:00 | Hi again, some formulas are more receptive than others to referencing multiple sheets. I think you would have to do this... =COUNTIF(Sheet1!F:F,"X")+COUNTIF(Sheet2!F:F,"X")+COUNTIF(Sheet3!F:F,"X") If your having trouble I suggest posting your question at Mr Excel (http://www.mrexcel.com/) as there are lots of people there with some very good Excel knowledge. You can also download Colos HTML Maker (link at bottom of all Mr Excel pages) which enables you to post example data including formulas which is very helpful to describe what you want done. |
parry (27) | ||
| 213871 | 2004-02-10 08:40:00 | parry, you are an officer & a gentleman. appreciate your time & help :-) | flying_green_leprachaun (1767) | ||
| 1 | |||||