sumifs for excel 2003 *compatible with alfanumeric target*

[bagullo]

hi there,

I've been looking around for a while and didn't find anything to work so I post it here

I am working with excel 2003 and I'm doing a macro that should put a Sumifs-like formula in a range

using the workaround with sumproduct((range1=cond1)*(range2=cond2)... *sumtarget) I managed to get all the conditions in, but the problem is that in the actual sum target there are numbers but also some entries with letters (which should be ignored)

I tried puting an extra condition with ISNUMBER(range) but even with that seems to break if a nonnumber is present (probably does not stop evaluating for that line)

can anyone recommend me some workaround to this problem??

the regular sumif present in excel 2003 seems not to mind the non numeric entries...


all help appreciated

[shg]

= sumproduct((range1=cond1)*(range2=cond2)... , sumtarget)

[bagullo]

wow! that was brief and effective!
thank you!!