Excel Auto Populate
Solved/Closed
Hello,
I've created a drop down list as B, I and A. on one sheet I need it to calculate the count automatically. The next sheet has coulmns saying B, I and A. When a is selected 5 times in sheet A it should say 5 under A in Sheet B. Is it possible.
I need you help. Thank you...
I've created a drop down list as B, I and A. on one sheet I need it to calculate the count automatically. The next sheet has coulmns saying B, I and A. When a is selected 5 times in sheet A it should say 5 under A in Sheet B. Is it possible.
I need you help. Thank you...
Related:
- Excel Auto Populate
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Grand theft auto iv download apk for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Auto redial samsung - Guide
- Op auto clicker download - Download - Mouse and keyboard
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 22, 2011 at 09:38 AM
Nov 22, 2011 at 09:38 AM
Hi Jebin,
Use the following aray formula:
=SUM(IF('Sheet A'!A1:A9="A",1,0))
An array formula needs to be confirmed by hitting Ctrl+Shift+Enter.
This will count how many A's are on Sheet A within the range A1:A9.
Best regards,
Trowa
Use the following aray formula:
=SUM(IF('Sheet A'!A1:A9="A",1,0))
An array formula needs to be confirmed by hitting Ctrl+Shift+Enter.
This will count how many A's are on Sheet A within the range A1:A9.
Best regards,
Trowa