Excel Auto Populate [Solved/Closed]

Report
-
 Jebin -
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

Posts
2619
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 26, 2020
419
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
Thanks a Million