Hi all I wondered if you could help me add together D3+G3+J3+M3+Q3+U3 and put the result into W3? I think the reason it wont work is because there will not always be a value in D3/G3 and J3/M3
Many thanks!New KS4 grades Markbook.xlsx
Hi all I wondered if you could help me add together D3+G3+J3+M3+Q3+U3 and put the result into W3? I think the reason it wont work is because there will not always be a value in D3/G3 and J3/M3
Many thanks!New KS4 grades Markbook.xlsx
Noncontiguous ranges are tough. The best I could come up with was:
=SUMIF(C$2:V$2,$D$2,C3:V3)
Drag down as needed.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Wow that's great, I don't understand the formula at all, but it appears to work!
=SUMIF(criteria range, criteria, sum range)
The formula looks at C2:V2, looks for UMS, and then adds up row 3 for each match of UMS.
Ah now I get it! thanks for the explanation!
Thanks for the feedback, glad I could help out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks