I have some cells that do a SUM calculation on the cells immediately above
(same column). I want to do the SUM calculation but I want to EXCLUDE one
specific cell. How do I do that?
I have some cells that do a SUM calculation on the cells immediately above
(same column). I want to do the SUM calculation but I want to EXCLUDE one
specific cell. How do I do that?
You could use the following =SUM(D7:D8,D10:D11) this would exclude D9 in the calculations.
Just subtract that cell from the overall sum
=SUM(A1:M1)-G1
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Peppermint" <[email protected]> wrote in message
news:[email protected]...
> I have some cells that do a SUM calculation on the cells immediately above
> (same column). I want to do the SUM calculation but I want to EXCLUDE one
> specific cell. How do I do that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks