«
»

EXCEL，将A列中相同代码所对应B列的数值进行自动求平均

C1输入=IF(COUNTIF(A$1:A1,A1)=1,AVERAGE(IF(A$1:A$100=A1,B$1:B$100)),””)数组公式，输入后先不要回车，按Ctrl+Shift+Enter结束计算，再向下填充。
Advertisements

This entry was posted on March 31, 2014 at 8:56 am and is filed under Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out / Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out / Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out / Change )

Google+ photo

You are commenting using your Google+ account. ( Log Out / Change )

Cancel

Connecting to %s