Average of different columns

**TallOne** · 04-12-2013, 09:29 AM

Hi

I have three different tables (in each table has two columns) and would like to calculate the average of these tables. See the attached files.

Thanks in Advance

**dredwolf** · 04-12-2013, 10:09 AM

Did you want the average of each column?, not exactly sure what you are looking for here

**TallOne** · 04-12-2013, 10:18 AM

Hi
Thanks for your reply

I want the average of the three tables (for example: the average of the second columns in the three table), not each columns. The problem is the the table are not in the same size (tables are not equal in number of rows).

Thanks

**mnjofra** · 04-12-2013, 10:37 AM

Hi TallOne,
try attached solution. This has sence for me...

Regards,

**mnjofra** · 04-12-2013, 10:44 AM

I add average graph too...

Regards,

**TallOne** · 04-12-2013, 01:08 PM

Hi mnjofra

Thanks for your help, I really appreciate it. Could you please describe to me the formula you used, particularly the multiplication by 1 (SUMPRODUCT(($A$3:$A$109=K8)*1,$B$3:$B$109)).

Thanks again for your help.

**TallOne** · 04-13-2013, 03:05 PM

Hi
Any help.

**Tony Valko** · 04-13-2013, 04:09 PM

See this for info on SUMPRODUCT:

http://xldynamic.com/source/xld.SUMPRODUCT.html

FWIW, that can be done with a SUMIF function:

=SUMIF($A$3:$A$109,K8,$B$3:$B$109)