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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 31, 2015 at 11:58 AM
Related:
- Sum value of one column if in another column there is a text
- Excel copy column from one sheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- How to convert column to row in notepad++ ✓ - Excel Forum
- Sum if greater than and less than cell value ✓ - Excel Forum
- How to increment numbers when value changes in another column? - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 31, 2015 at 11:58 AM
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.
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.