Discussion Sum and Counting Function in Excel
https://techcommunity.microsoft.com/t5/excel/sum-and-counting-function/m-p/2113489#M88204
<P>Hi, </P><P>I have been trying to count and sum a row of "x" in a matrix structure, based on text in another line.</P><P> </P><P>in cell D10, I would like to show the sum of "x" across the row AO10:ZZ10 only if there is corresponding text in the cell AO5 </P><P>this should show D10 being 2</P><P> </P><P>and again in cell E10, sum up the "x" in row AO10:ZZ10 only if there is a corresponding text in cell AO4</P><P>This should show E10 being 1</P><P> </P><P>any help would be gratefully appreciated.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Alastair674_1-1612399870892.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/252164iCCDBEAAC1152AC07/image-size/medium?v=v2&px=400" role="button" title="Alastair674_1-1612399870892.png" alt="Alastair674_1-1612399870892.png" /></span></P><P> </P><P> </P>Thu, 04 Feb 2021 01:19:21 GMTAlastair6742021-02-04T01:19:21ZSum and Counting Function
https://techcommunity.microsoft.com/t5/excel/sum-and-counting-function/m-p/2113489#M88204
<P>Hi, </P><P>I have been trying to count and sum a row of "x" in a matrix structure, based on text in another line.</P><P> </P><P>in cell D10, I would like to show the sum of "x" across the row AO10:ZZ10 only if there is corresponding text in the cell AO5 </P><P>this should show D10 being 2</P><P> </P><P>and again in cell E10, sum up the "x" in row AO10:ZZ10 only if there is a corresponding text in cell AO4</P><P>This should show E10 being 1</P><P> </P><P>any help would be gratefully appreciated.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Alastair674_1-1612399870892.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/252164iCCDBEAAC1152AC07/image-size/medium?v=v2&px=400" role="button" title="Alastair674_1-1612399870892.png" alt="Alastair674_1-1612399870892.png" /></span></P><P> </P><P> </P>Thu, 04 Feb 2021 01:19:21 GMThttps://techcommunity.microsoft.com/t5/excel/sum-and-counting-function/m-p/2113489#M88204Alastair6742021-02-04T01:19:21ZRe: Sum and Counting Function
https://techcommunity.microsoft.com/t5/excel/sum-and-counting-function/m-p/2113589#M88216
<P><LI-USER uid="954329"></LI-USER> Created a mock-up worksheet based on your screen shot. See if it works for you. Am using SUMPRODUCT to count the number of x's on row 10, if a row above it is NOT blank. In D10 it looks for text in row 5, in E10 it looks for text in row 4. Assuming you want a similar calculation in F10 and G10, you can change the formula so that the last part of it points to rows 3 and 2 respectively. </P>Thu, 04 Feb 2021 06:23:34 GMThttps://techcommunity.microsoft.com/t5/excel/sum-and-counting-function/m-p/2113589#M88216Riny_van_Eekelen2021-02-04T06:23:34ZRe: Sum and Counting Function
https://techcommunity.microsoft.com/t5/excel/sum-and-counting-function/m-p/2113670#M88227
<P><LI-USER uid="403176"></LI-USER> </P><P>Thanks so much <LI-USER uid="403176"></LI-USER> , formula worked perfectly.</P><P>I was able to use that on several other aspects of the matrix.</P><P> </P><P> </P><P>Thanks again.</P>Thu, 04 Feb 2021 08:21:44 GMThttps://techcommunity.microsoft.com/t5/excel/sum-and-counting-function/m-p/2113670#M88227Alastair6742021-02-04T08:21:44ZRe: Sum and Counting Function
https://techcommunity.microsoft.com/t5/excel/sum-and-counting-function/m-p/2113695#M88230
<P><LI-USER uid="954329"></LI-USER> Glad you could get it to work!</P>Thu, 04 Feb 2021 08:58:52 GMThttps://techcommunity.microsoft.com/t5/excel/sum-and-counting-function/m-p/2113695#M88230Riny_van_Eekelen2021-02-04T08:58:52Z