Sum value of one column if in another column there is a text

Closed
Europeoffice - Aug 31, 2015 at 08:37 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Aug 31, 2015 at 11:58 AM
Hello,


I am trying to sum values in column A if in column B there is a certain number.

So,

Column A
10
20
30
40
50

Column B
E45DISK
20D
P30POOL
P60TASK
45PROW

I wanna sum only those value of column A when in the respective row in column B there is the number 45. So, in this case, I wanna sum only 10 (E45DISK), 50 (45PROW). Can someon ehelp me with this? Thanks a lot, I tried in many ways but I can't figure out s solution

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Aug 31, 2015 at 11:58 AM
Europeoffice, Good afternoon.

Try to use:

ARRAY FORMULA
=SUM(IF(IFERROR(FIND(45,B1:B5),0),A1:A5,0))

Is that what you're looking for?
I hope it helps.
0