SUMIF Question

M

mksullvn

I used the SUMBYCOLOR option, but it still came back #NAME? maybe I a
doing something wrong, but the text is red and the range of cells i
A1:A10, so I used the function

=SUMBYCOLOR(A1:A10,3,FALSE) and I tried it with spaces betwee
commas...do these formulas not work with Excel 2000? Or maybe I a
just really confuse
 
F

Frank Kabel

Hi
you first have to put the VBA code in a standard module of your
workbook
 
M

mzehr

I am using 2000 and it works for me.
Did you post the VB code in a module?
Also note that you will need to change the False to True
for Text. False looks at cell interior color.
 
Top