Summing column totals

[devonalex]

On the attached sheet, I need to place in C20, the sum of row F7:XFD7 where Row F2:XFD2 = 1

Could someone please advise as to which formula function would be best please. I tried SUMPRODUCT but could not get it to work

Thanks
A
2016.xlsx2016.xlsx

[Jonmo1]

Try the SUMIF function

=SUMIF(F2:XFD2,1,F7:XFD7)

[Pete_UK]

You can use this formula in C20:

=SUMIFS(F7:XFD7,F$2:XFD$2,1)

Do you really need to use all those columns?

Hope this helps.

Pete

[bebo021999]

Try:
=SUMIF($F$2:$XFD$2,ROW(1:1),$F$7:$XFD$7)
Drag down for next weeks

[devonalex]

Thanks Everyone - that was great

Pete: probably not - but I don't know how long the sheet will be used, so better safe than sorry

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )