Forum Discussion
Solved
Sum Values of a cell that start with same text
Hello, I am trying to set up a formula where I can sum up the values of a cell that start with a certain text. Here is my spreadsheet, column I totals the values entered on the row (O3:no3) an...
For example:
=SUM(IF(LEFT(O3:NO3)="S",--MID(O3:NO3,2,2)))
=SUM(IF(LEFT(P3:NZ3)="F",--MID(P3:NZ3,2,2)))
If you don't have Excel in Microsoft 365 or Office 2021, you'll have to confirm the formulas with Ctrl+Shift+Enter, to turn them into array formulas.
For example:
=SUM(IF(LEFT(O3:NO3)="S",--MID(O3:NO3,2,2)))
=SUM(IF(LEFT(P3:NZ3)="F",--MID(P3:NZ3,2,2)))
If you don't have Excel in Microsoft 365 or Office 2021, you'll have to confirm the formulas with Ctrl+Shift+Enter, to turn them into array formulas.
@hansvogelaar Thank you, thank you, thank you so very much. I had been working on this formula for over a month and thanks to your assistance I was able to enter it within hours. While I learned a lot while researching excel's formula functions thru the month I wish I had reached out sooner for help. Stay healthy and again THANK YOU!