Thread: Adding Data Validation Values

Hello-

I'm kinda new to excel and need some help. I have two colums with data validation, in column A - name of bank (wells fargo, chase), then column B is type of accounts (checking, savings), I have this as INDIRECT based on what is picked from column A. The third column just has amounts of deposits.

My question is, how do I add up what is in the deposits column based on which bank was picked in column A?

I would like it to be something like this:

BANK NAME TOTAL AMOUNT
Wells Fargo (here would be the total amount deposited in Wells Fargo)
Chase (here would be the total amount deposited in Chase)

I don't even know if i'm explaining this clearly.

Any help would be appreciated. Thank you!

Welcome to the forum. Look at a SUMIF formula. =SUMIF(A1:A100,"Wells Fargo",C1), for example. Also, this particular section isn't appropriate for your question. Worksheet Functions or New Users would have been better.

Mods, could one of you please move this to the appropriate section? Thanks.