medium10 pts · first answer countsexcelcell-references

Summing the same cell on many sheets

A workbook has sheets Jan, Feb and Mar in that order. A Summary sheet uses =SUM(Jan:Mar!B5). Someone inserts a sheet named "Notes" between Feb and Mar. What happens?

A.Notes is ignored as it is not a monthB.The formula shows #REF! until fixedC.B5 on Notes is now included in the totalD.Only Jan and Mar are summed by the formula from now on

Discussion 0

Join free to post in the discussion.

Summing the same cell on many sheets

Discussion 0

Related questions