Find Serial Number and input Average Value into Adjacent cell
Solved/Closed
Related:
- Find Serial Number and input Average Value into Adjacent cell
- How to input @ in laptop - Guide
- Lg tv change input name ✓ - Smart TV Forum
- User information is error please input again - Google Chrome Forum
- Nero 6 serial number - Software Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 15, 2016 at 11:49 AM
Feb 15, 2016 at 11:49 AM
Hi Cindy,
This is what I did:
Sheet1
Sheet2
A2: da1
B2: =AVERAGEIF(Sheet1!A2:A6,A2,Sheet1!B2:B6)
B2 shows the value "5.5".
Can you make it work now?
Best regards,
Trowa
This is what I did:
Sheet1
H1 H2
x09da123 10
da1 10
x09da123 1
da1 1
da3 1
Sheet2
A2: da1
B2: =AVERAGEIF(Sheet1!A2:A6,A2,Sheet1!B2:B6)
B2 shows the value "5.5".
Can you make it work now?
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 15, 2016 at 11:23 AM
Feb 15, 2016 at 11:23 AM
Hi Cindy,
You could try using the AVERAGEIF formula:
=AVERAGEIF(Column with s/n, the s/n you want to look up, column with values)
Best regards,
Trowa
You could try using the AVERAGEIF formula:
=AVERAGEIF(Column with s/n, the s/n you want to look up, column with values)
Best regards,
Trowa
Feb 15, 2016 at 11:59 AM