|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 9th, 2009, 08:22 PM
posted to microsoft.public.word.tables
|
|||
|
|||
Formula Average
Okay, I give up. I've tried everything possible...except obviously the RIGHT
thing!! I'm trying to do a formula in a table that will average a bunch of cells. I can average the cells as long as they're contiguous, but I don't know how to add the one that's separate. I'm trying to average what's in cells H21, H23, H25, H27, H29, H31 and the troublemaker...B7 and then divide all that by 2 (or multiply by .50). I've tried many different things, but this is one of my tries because maybe it'll be clearer what I'm trying to do seeing it this way. Everything I do gives me a syntax error!! Please help!! =AVERAGE(H21:H31+B7)/2 
|
|
#2
December 9th, 2009, 09:26 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
Formula Average
Hi Ginny,
Code the formula field as: {=AVERAGE(H21,H23,H25,H27,H29,H31,B7)/2} Note: Apart from the syntax error, the formula you tried includes H22,H24,H26,H28 & H30 in the averages. -- Cheers macropod [Microsoft MVP - Word] "Ginny_NG" wrote in message ... Okay, I give up. I've tried everything possible...except obviously the RIGHT thing!! I'm trying to do a formula in a table that will average a bunch of cells. I can average the cells as long as they're contiguous, but I don't know how to add the one that's separate. I'm trying to average what's in cells H21, H23, H25, H27, H29, H31 and the troublemaker...B7 and then divide all that by 2 (or multiply by .50). I've tried many different things, but this is one of my tries because maybe it'll be clearer what I'm trying to do seeing it this way. Everything I do gives me a syntax error!! Please help!! =AVERAGE(H21:H31+B7)/2
|
|
#3
December 10th, 2009, 10:52 AM
posted to microsoft.public.word.tables
|
|||
|
|||
|
Formula Average
Hi Ginny,
Try: =(AVERAGE(H21:H31,B7))/2 Regards Chris "Ginny_NG" wrote: Okay, I give up. I've tried everything possible...except obviously the RIGHT thing!! I'm trying to do a formula in a table that will average a bunch of cells. I can average the cells as long as they're contiguous, but I don't know how to add the one that's separate. I'm trying to average what's in cells H21, H23, H25, H27, H29, H31 and the troublemaker...B7 and then divide all that by 2 (or multiply by .50). I've tried many different things, but this is one of my tries because maybe it'll be clearer what I'm trying to do seeing it this way. Everything I do gives me a syntax error!! Please help!! =AVERAGE(H21:H31+B7)/2
|
|
#4
December 11th, 2009, 01:39 AM
posted to microsoft.public.word.tables
|
|||
|
|||
|
Formula Average
Well, son of a gun! See, I told you I tried everything except the right
thing! LOL! Yup, that worked. Thank you so much, Chris! "Chris" wrote: Hi Ginny, Try: =(AVERAGE(H21:H31,B7))/2 Regards Chris "Ginny_NG" wrote: Okay, I give up. I've tried everything possible...except obviously the RIGHT thing!! I'm trying to do a formula in a table that will average a bunch of cells. I can average the cells as long as they're contiguous, but I don't know how to add the one that's separate. I'm trying to average what's in cells H21, H23, H25, H27, H29, H31 and the troublemaker...B7 and then divide all that by 2 (or multiply by .50). I've tried many different things, but this is one of my tries because maybe it'll be clearer what I'm trying to do seeing it this way. Everything I do gives me a syntax error!! Please help!! =AVERAGE(H21:H31+B7)/2
|
|
#5
December 11th, 2009, 02:36 AM
posted to microsoft.public.word.tables
|
|||
|
|||
|
Formula Average
Hi Ginny,
Be aware that Chris' formulation includes H22,H24,H26,H28 & H30 in the averages. Your post indicated they were not to be included; doing so could lead to erroneous results. -- Cheers macropod [Microsoft MVP - Word] "Ginny_NG" wrote in message ... Well, son of a gun! See, I told you I tried everything except the right thing! LOL! Yup, that worked. Thank you so much, Chris! "Chris" wrote: Hi Ginny, Try: =(AVERAGE(H21:H31,B7))/2 Regards Chris "Ginny_NG" wrote: Okay, I give up. I've tried everything possible...except obviously the RIGHT thing!! I'm trying to do a formula in a table that will average a bunch of cells. I can average the cells as long as they're contiguous, but I don't know how to add the one that's separate. I'm trying to average what's in cells H21, H23, H25, H27, H29, H31 and the troublemaker...B7 and then divide all that by 2 (or multiply by .50). I've tried many different things, but this is one of my tries because maybe it'll be clearer what I'm trying to do seeing it this way. Everything I do gives me a syntax error!! Please help!! =AVERAGE(H21:H31+B7)/2
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
