Software

Ask something
Question Locked

EXCEL formula help

0 helpful
2 replies

by dawn.prentice

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to understand why excel is not allowing the same formula, that exists both above and below... I am only doing a sum of 7 cells on the same row? but if I enter the formula even with prens, or begin the formul with a 0, or even backward, I get #VALUE!
I need this value to be correct for other formulas to work. Got any sugestions?

2 replies

by absolutely

I'm guessing your formula is on rows A & C, and look like:
=SUM(B1:B7)
Is that right?

It would help if you'd post the text of your function, showing which one works, which one doesn't, etc.

This discussion is closed to new replies.