Excel Auto Populate
Solved/Closed
Related:
- Excel Auto Populate
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Grand theft auto iv download apk for pc - Download - Action and adventure
- Nvidia drivers auto detect - Guide
- Auto redial samsung - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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