sumif error

[rodolform]

I´m adding values from 3 diferent tables with this formula

=sumif (a1:a200,"rh",b1:b200)+sumi
(x1:x200,"rh",y1:y200)+sumif(af1:af200,"rh",ag1:ag200)

But I cant make it work because it just shows me the formula in th
cell but no calculation is made, it works when I use two tables but n
with 3.

Thanks for your help

Rodolf

 

[firefytr]

hi there,

=SUMIF(A1:A200,"rh",B1:B200)+SUMIF(X1:X200,"rh",Y1:Y200)+SUMIF(AF1:AF200,"rh",AG1:AG200)

works for me?

have you widened the column to compensate for computational return?
and is calculation set to automatic? you did post your formula wit
spaces, is it like that in your workbook?

if it's still adding, just not finding your 'criteria', maybe you nee
to check your criteria

 

[Jerry W. Lewis]

On the menu, select Tools|Options|View and if Formulas is checked,
uncheck it.

If not checked, check to see if the cell is formatted as text. If so,
change to General or a numeric format and re-enter the formula.

Jerry

 

[rodolform]

I've found the problem, every time I edit the formula the cell forma
changes from general to text, it's driving me crazy¡¡¡¡¡

So I have to change the format, and then wriote the formula again.

Does anyone knows how can I prevent this from happening??

 

[firefytr]

hello Rodolfo,

if you right click your sheet name -> View Code, do you see anything i
the right frame entitled "Private Sub Worksheet_Change(..."?

 

[rodolform]

Hi Zack:

Under worksheet it has the folowing:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub


Don´t know how it got there...

Should I remove it????

Thanks.

Rodolf

 

[rodolform]

Hi Zack:

Under worksheet it has the folowing:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub


Don´t know how it got there...

Should I remove it????

Thanks.

Rodolf

 

[rodolform]

Hi Zack:

Under workseet it has:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

I don´t know how it got there, should I remove it????

Thanks.

Rodolf

 

[rodolform]

Sorry for the multiple postings, I have deleted them.

Rodolfo...

 

[firefytr]

well if there is nothing in between those two lines, it's not firing o
anything. as in, no code is being executed. so yes, delete it, a
it's really a waste and misleading.

you should also check This Workbook, below your sheets in the Visua
Basic Editor (Alt + F11 from Excel), to see if there may be somethin
in there. also, any modules with macros that have maybe affecte
things? probably worth a check

 

[rodolform]

Thank's for the response, but I can´t find the way to erase that code
I'm sure that it's child play but I'm not that familiar with cod
handiling.

What i did was delete the code and then closed the window, but if
open it once again the code still there.

This WS used to have a macro that made cells change colors when yo
point at them but people at office told me that it was already clean
how can I check this up????

Rodolfo

 

[Peo Sjoblom]

Select the code and delete it, close the VBE and save the workbook

 

[rodolform]

Done that and the code still there, in the window "general" nothing
apears but under the window "worksheet" the code apears every time.