Average Issue

[urgenthelp]

Hi guys, new to the forums.

Trying to get some help with some issue that I am facing with averages. I've attached the file via link. Please check and help.

Thanks in advance.

 

[Shrikant]

there's not link in your post.

 

[urgenthelp]

Updated on dropbox. https://www.dropbox.com/s/7qvc4bnkuw1lbue/Book3.xlsx

 

[Aladin Akyurek]

Hi guys, new to the forums.

Trying to get some help with some issue that I am facing with averages. I've attached the file via link. Please check and help.

Thanks in advance.

Try to explain/word the issue you have here instead of pointing to a file that contains no explanation but just too much data... Try to illustrate the issue with a drastically reduced sample of data along with the expected actual result(s).

 

[AliGW]

there's not link in your post.

The word "link" is the link.

 

[AliGW]

We need much more information about the nature of the problem, but my best guess is that this will be a rounding issue.

 

[vogel997]

Hi guys, new to the forums.

Trying to get some help with some issue that I am facing with averages. I've attached the file via link. Please check and help.

Thanks in advance.

=SUMPRODUCT(--($A$1:$S$1=U$1),$A2:$S2)/SUMPRODUCT(--($A$1:$S$1=U$1),--($A2:$S2>0)) copy formula into cell "U2", then copy to the rest of the cells. <colgroup><col width="904" style="width: 678pt; mso-width-source: userset; mso-width-alt: 33060;"> <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[vogel997]

Hi guys, new to the forums.

Trying to get some help with some issue that I am facing with averages. I've attached the file via link. Please check and help.

Thanks in advance.

your original formula doesn't include the data from column "m,n & o"

just add it and it will work as well.

<colgroup><col width="904" style="width: 678pt; mso-width-source: userset; mso-width-alt: 33060;"> <tbody> </tbody>

 

[Shrikant]

The word "link" is the link.

How Clever!

 

[Aladin Akyurek]

=SUMPRODUCT(--($A$1:$S$1=U$1),$A2:$S2)/SUMPRODUCT(--($A$1:$S$1=U$1),--($A2:$S2>0)) copy formula into cell "U2", then copy to the rest of the cells. <TBODY> </TBODY> <TBODY> </TBODY>

<TBODY>
</TBODY>

The OP is missed an opportunity to describe the problem...

If you insist on SumProduct...

=SUMIF($A$1:$S$1,U$1,$A2:$S2)/SUMPRODUCT(--($A$1:$S$1=U$1),--($A2:$S2>0))

would be a tad faster.

Even better, because the OP appears to be on a post 2003 system:

=AVERAGEIFS($A2:$S2,$A$1:$S$1,U$1,$A2:$S2,">0")