sumproducts producing #value errors

[augy]

SUMPRODUCT(--(RawMarketers=$C$3),--(RawDateGap))/(SUMPRODUCT(--(RawMarketers=$C$3)))

RawMarketers and RawDateGap are names for specific columns, where RawMarketers = names of various marketers and RawDateGap = the amount of time between when appointments they create. In this formula, I am attempting to get the average daily gap between appointments.

Unfortunately, in my RawDateGap column there are blank cells where there should be numbers, simply because the data cannot be counted for those appointments, so no data exists.

I am not sure how to find the average gap, if this is the case.

[NBVC]

You don't use the -- on the summing range...

check range sizes (they should be the same)

check for value error in the ranges

check for text in the summing range...

=SUMPRODUCT(--(RawMarketers=$C$3),RawDateGap)/(SUMPRODUCT(--(RawMarketers=$C$3)))

[DonkeyOte]

If as it seems the data is stored in the same file as the calculation itself then there is no need for SUMPRODUCT at all

=SUMIF(RawMarketers,$C$3,RawDateGap)/COUNTIF(RawMarketers,$C$3)

which would be more efficient

or if using XL2007+ use AVERAGEIF