Problem with SUM and AVERAGE functions...

[hallingh]

Hi all,

I have an interesting problem. I am working with an Excel sheet that is only using native excel functions (no vba involved.) On one of the sheets, I am using the Sum function and the average function. The values which I'm summing and averaging have been imported from an infopath form to another Excel sheet, and then copied into the sheet I'm working with.

When I put this into a cell:

=AVERAGE(Q51:AB51)

It gives me a Div/0 error. When I use this:

=SUM(Q51:AB51)

it just gives me 0 as the answer.

The cells Q51:AB51 are using the index function to retrieve the values from another sheet, but are showing the values I want, all of which are integers between 1 and 4.

Does anyone have any idea why these functions would not be working for me?

I'm completely lost. Also, I have used this sheet before, and imported previous values the same way through infopath. The SUM and AVERAGE functions are working as intended on the values that have already been entered into the sheet.

THanks for the looks and for any help you can give me.

Hank

 

[VoG]

It sounds like you have numbers stored as text. Try typing 0 into an empty cell, copy it, select your numbers, Edit > Paste Special, check Add and click OK.

 

[hallingh]

Nevermind, I got it. I imported the numbers from infopath onto a different sheet, and even though the cells were formatted as numbers, it was still storing the number as text when it got imported.

 

[hallingh]

Ah, you beat me to it!

THanks for the look VoG.

Hank