Do I need a program?

[Phosphonothioic]

Say you have two columns, A & B.

Each cell in column A consists of an identical drop-down menu of four possible choices. Each cell in B is a random number.

I want to sum the cells in B according to what the user selects from the drop down in column A.

If A1=A2="BILL", I want the sheet to add B1 and B2.

IF A1=A3="BILL", and A2=A4=TOM, I want the sheet to sum B1 and B3, then sum A2 and A4.

So, conceptually, I guess column A acts as a group identifier, and I want to sum B by group.

Can this be done?

[Phosphonothioic]

Just stumbled on SUMIF...sorry for wasting your time.

[royUK]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

I suggest you read all the Forum Rules & make sure that your future thread titles comply.