Excel Auto Populate

Solved/Closed
Jebin - Nov 17, 2011 at 05:25 AM
 Jebin - Nov 22, 2011 at 10:45 PM
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...

2 replies

TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
515
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
0
Thanks a Million
0