Excel find word in series of cells and add
Solved/Closed
Related:
- Excel find word in series of cells and add
- Pdf and xps add in 2007 - Download - Other
- Number to word in excel - Guide
- How to add photo in word resume - Guide
- How to add watermark in word - Guide
- Word apk for pc - Download - Word processors
2 responses
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Sep 2, 2009 at 05:20 PM
Sep 2, 2009 at 05:20 PM
Hi,
According to your example, the formula in D15, to add the values of all cells in column B which correspond to all the cells in column A containing the word "January" is :
=SUMIF(A:A,"*January*",B:B)
in D216, you just have to change "January" by "February" :
=SUMIF(A:A,"*February*",B:B)
Do the same to the other months.
Best regards
According to your example, the formula in D15, to add the values of all cells in column B which correspond to all the cells in column A containing the word "January" is :
=SUMIF(A:A,"*January*",B:B)
in D216, you just have to change "January" by "February" :
=SUMIF(A:A,"*February*",B:B)
Do the same to the other months.
Best regards
Mar 17, 2017 at 11:46 PM