Excel Auto Populate Solved/Closed

Question

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...

TrowaD · Answer

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

Jebin · Answer

Thanks a Million

Excel Auto Populate

2 responses

Similar discussions

Subscribe To Our Newsletter!