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
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 31 Aug 2015 à 11:58
Related:
- Sum value of one column if in another column there is a text
- Excel column number - Guide
- How to delete a column in word - Guide
- Tweetdeck expand column - Guide
- Excel count number of occurrences in a column - Guide
- Vba find column ✓ - Excel Forum
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
31 Aug 2015 à 11:58
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.
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.