Formula to Find a Row then Add Data From that Row

[k2timmy]

I'm looking for the formula that will search a table or a range for a "Name" in the first column, then add up data I choose (Fruit) from that specific row. For example, if I want to search for "Bob" then add up the total amount of times he chose "Apple".

Data to Input:

F1: Name
F2: Fruit

Thank you to anyone who can help!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also will the name in col A only occur once, or could it occur multiple times?

 

[Jeffrey Mahoney]

Try this
=COUNTIFS(A:A,F1,B:B,F2)+COUNTIFS(A:A,F1,C:C,F2)+COUNTIFS(A:A,F1,D:D,F2)

 

[Fluff]

Another option would be

=SUMPRODUCT((A1:A8=F1)*(B1:D8=F2))

 

[Jeffrey Mahoney]

Nice one Fluff!

 

[k2timmy]

Try this
=COUNTIFS(A:A,F1,B:B,F2)+COUNTIFS(A:A,F1,C:C,F2)+COUNTIFS(A:A,F1,D:D,F2)

Thank you!!!

 

[k2timmy]

Another option would be

=SUMPRODUCT((A1:A8=F1)*(B1:D8=F2))

Worked great, thanks!

 

[Fluff]

Glad we could help & thanks for the feedback.

Please don't forget this

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[k2timmy]

Glad we could help & thanks for the feedback.

Please don't forget this

I just updated my account details. Thanks for that tip and for the speedy response.

 

[Fluff]

I just updated my account details.

Many thanks for that.