Thanks for helping. I hope I'm not taking advantage of your help but could I
send you my spread sheet and show you what I am trying to accomplish? I know
there has to be an easier way in excel to do what I want(I'm not trying to
get that complicated) but I'm not explaining it well.
Eric
"Max" wrote:
"eric" wrote:
Can I do sumif when the range is not continuous?? example
=sumif(a4,a24,a34,a44,"0",(b4,b24,b34,b44))
Don't think so. I suppose you have your reasons why you can't use the entire
range A4:A44. One quick workaround. In an empty col to the right, say col E,
do a one-time manual flagging by inputting say: x into the corresponding
cells: e4,e24,e34,e44.
Then you could point the SUMIF to col E,
and use: =SUMIF(E2:E44,"x",B2:B44)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---