=sumif(a1:a3,"median(a1:a3)") always gives 0. What to do?
 

=sumif(a1:a3,"median(a1:a3)") always gives 0. What to do?
 

"Bill Friedman" wrote

=sumif(a1:a3,"median(a1:a3)") always gives 0. What to do?

Try it as: =SUMIF(A1:A3,""&MEDIAN(A1:A3))


Note: When posting, **do not** leave the message area blank. Always describe
/ re-describe your query / issue within the message area. The subject line
is just that, it isn't meant to be the posting.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---