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

Closed
Europeoffice - 31 Aug 2015 à 08:37
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 31 Aug 2015 à 11:58
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
Related:

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
31 Aug 2015 à 11:58
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.