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

[Closed]
Report
-
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 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
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!