Banks not adding based on formular assigned

[[email protected]]

Please in the attached, I have a column that adds all the transaction amounts based on their respective banks. My problem is that First Bank and Ecobank are not adding. Can anyone please help me out?

[Ace_XL]

The anomaly is on account of an extra space (at the end) in your 'Banks' list.

Try this ..

In AD3 change formula to

Please Login or Register  to view this content.

copy down

[[email protected]]

Oh thanks greatly. I removed the extra spaces and the thing worked like miracle. I appreciate