Previous Topic Next Topic

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

Closed
Europeoffice - Aug 31, 2015 at 08:37 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses
Sum values from one column if another column equals x
Sarah -
vcoolio -

3 responses
VBA find column by name and sort
SidK -
bOFILL -

4 responses