Add numbers from cells in column A, depending on text in column B

[Panthera]

I'm having a small problem getting a workable solution created for the below.

My data
- In column A, I have range of percentage values, accumulating to 100%. Each row can have a value of anything from 0.01% up to 100%.
- In Column B, next to the percentage value, I have a text value which is either "Y, N or TBD"

My problem
- I'm trying to summarize all percentage values for each Y, N and TBD entered.

E.g.

ROW 1, 10%, Y
ROW 2, 10%, Y
ROW 3, 20%, N
ROW 4, 50%, TBD
ROW 5, 10%, Y

The outcome should then look like this and change depending on the text value
Y = 30%
N = 20%
TBD = 50%

Hope the above is clear enough

 

[Legacy 143009]

I'm having a small problem getting a workable solution created for the below.

My data
- In column A, I have range of percentage values, accumulating to 100%. Each row can have a value of anything from 0.01% up to 100%.
- In Column B, next to the percentage value, I have a text value which is either "Y, N or TBD"

My problem
- I'm trying to summarize all percentage values for each Y, N and TBD entered.

E.g.

ROW 1, 10%, Y
ROW 2, 10%, Y
ROW 3, 20%, N
ROW 4, 50%, TBD
ROW 5, 10%, Y

The outcome should then look like this and change depending on the text value
Y = 30%
N = 20%
TBD = 50%

Hope the above is clear enough

A pivot table can help. Select your data with headers. Navigate to Insert menu and click Pivot Table. Click OK.

Drag Column B values to Rows section. Drag Column A values to Values section. You may either sum or take the avarage of values by right clicking them.

 

[Panthera]

Ah so simple, not sure why I didn't think of that. Especially since this data was extracted from another pivot table I created earlier Zzz... Must have been staring myself blind on that IF(A:A="Y",.... ) statement trying to get it to do something.

Thank you for the elegant solution Flashbond. Much appreciated

 

[Legacy 143009]

Ah so simple, not sure why I didn't think of that. Especially since this data was extracted from another pivot table I created earlier Zzz... Must have been staring myself blind on that IF(A:A="Y",.... ) statement trying to get it to do something.

Thank you for the elegant solution Flashbond. Much appreciated

Thanks for the feedback! You're welcome