Discussion sum in Excel
https://techcommunity.microsoft.com/t5/excel/sum/m-p/3320885#M145290
<P>I have a list of names in Droplist and I have a separate table in the same sheet to calculate the working hours. I want when this finds for example the name George to sum up the total hours that have been registered for him each time. I imagine that they are done with if. Can you help me with this function?</P>Thu, 05 May 2022 07:54:53 GMTtttt_tt2022-05-05T07:54:53Zsum
https://techcommunity.microsoft.com/t5/excel/sum/m-p/3320885#M145290
<P>I have a list of names in Droplist and I have a separate table in the same sheet to calculate the working hours. I want when this finds for example the name George to sum up the total hours that have been registered for him each time. I imagine that they are done with if. Can you help me with this function?</P>Thu, 05 May 2022 07:54:53 GMThttps://techcommunity.microsoft.com/t5/excel/sum/m-p/3320885#M145290tttt_tt2022-05-05T07:54:53ZRe: sum
https://techcommunity.microsoft.com/t5/excel/sum/m-p/3321365#M145295
<P><LI-USER uid="1381645"></LI-USER> </P><LI-CODE lang="applescript">=SUMIF($G$4:$G$27,C4,$H$4:$H$27)</LI-CODE><P>Maybe with this formula if the dropdown is in cell C4 and the separate table in range $G$4:$H$27.</P><P> </P>Thu, 05 May 2022 08:22:46 GMThttps://techcommunity.microsoft.com/t5/excel/sum/m-p/3321365#M145295Quadruple_Pawn2022-05-05T08:22:46ZRe: sum
https://techcommunity.microsoft.com/t5/excel/sum/m-p/3321591#M145302
CAN I ADD SECOND COOLUMN AFTER C4? FOR EXAMLE ($J$4:$J$27) CAN I ADD THIS, TO SUM THE TOTAL OF TWO COLUMS?<BR />IF YES, HOW I CAN DO THIS?Thu, 05 May 2022 09:08:37 GMThttps://techcommunity.microsoft.com/t5/excel/sum/m-p/3321591#M145302tttt_tt2022-05-05T09:08:37ZRe: sum
https://techcommunity.microsoft.com/t5/excel/sum/m-p/3321687#M145304
<P><LI-USER uid="1381645"></LI-USER> </P><LI-CODE lang="applescript">=SUMPRODUCT(($G$4:$G$27=C4)*(MOD(COLUMN(H:J),2)=0)*$H$4:$J$27)</LI-CODE><P>Maybe with this formula if you want to sum only the values in ranges <SPAN>$H$4:$H$27 and $J$4:$J$27 (columns H and J excluding column I).</SPAN></P>Thu, 05 May 2022 09:27:43 GMThttps://techcommunity.microsoft.com/t5/excel/sum/m-p/3321687#M145304Quadruple_Pawn2022-05-05T09:27:43Z