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

Closed
Report
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
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

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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.