Discussion Re: Sum Values of a cell that start with same text in Excel
https://techcommunity.microsoft.com/t5/excel/sum-values-of-a-cell-that-start-with-same-text/m-p/2865803#M118746
@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!Wed, 20 Oct 2021 15:56:23 GMTdioselinemenasha2021-10-20T15:56:23ZSum Values of a cell that start with same text
https://techcommunity.microsoft.com/t5/excel/sum-values-of-a-cell-that-start-with-same-text/m-p/2863078#M118627
<P>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.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dioselinemenasha_0-1634676190275.png" style="width: 747px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/318537iCC909244BE3AFE69/image-dimensions/747x99?v=v2" width="747" height="99" role="button" title="dioselinemenasha_0-1634676190275.png" alt="dioselinemenasha_0-1634676190275.png" /></span></P><P>Here is my spreadsheet, column I totals the values entered on the row (O3:no3) and subtracts from the vacation start total, but now I am also wanting to have column M total the values in that same row (o3:no3) that start with S, and column N to total the values that start with F.</P><P> </P><P>I have tried the following formulas but neither work:</P><P>(SUMIF(O3:NO3,"S#", O3:NO3))</P><P>(SUM(IF(P3:NZ3="f#", "0#", P3:NZ3)))</P><P> </P><P>I added conditional formatting so that when I enter S# the cell will change to blue color and when I enter F# it will change to blue so if you can assist with a formula that will grasp that and provide the totals that works for me too</P><P>Please help, I would like to avoid adding more rows since my table will already have 300 names to it</P><P> </P><P> </P>Tue, 19 Oct 2021 20:48:53 GMThttps://techcommunity.microsoft.com/t5/excel/sum-values-of-a-cell-that-start-with-same-text/m-p/2863078#M118627dioselinemenasha2021-10-19T20:48:53ZRe: Sum Values of a cell that start with same text
https://techcommunity.microsoft.com/t5/excel/sum-values-of-a-cell-that-start-with-same-text/m-p/2863202#M118628
<P><LI-USER uid="1190195"></LI-USER> </P>
<P>For example:</P>
<P>=SUM(IF(LEFT(O3:NO3)="S",--MID(O3:NO3,2,2)))</P>
<P>=SUM(IF(LEFT(P3:NZ3)="F",--MID(P3:NZ3,2,2)))</P>
<P>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.</P>
<P> </P>Tue, 19 Oct 2021 21:31:55 GMThttps://techcommunity.microsoft.com/t5/excel/sum-values-of-a-cell-that-start-with-same-text/m-p/2863202#M118628Hans Vogelaar2021-10-19T21:31:55ZRe: Sum Values of a cell that start with same text
https://techcommunity.microsoft.com/t5/excel/sum-values-of-a-cell-that-start-with-same-text/m-p/2865803#M118746
@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!Wed, 20 Oct 2021 15:56:23 GMThttps://techcommunity.microsoft.com/t5/excel/sum-values-of-a-cell-that-start-with-same-text/m-p/2865803#M118746dioselinemenasha2021-10-20T15:56:23Z