What exactlyt are you trying to do?

D565:D588 = 24 rows x 1 column
D7:IV7 (where did the ":IV7" come from?) = 1 row x 253 columns

It doesn't help much to say "the helper column didnt work" if you don't
explain what it was supposed to do, or how you tried to use it...



In article ,
Rob wrote:

The helper column didnt work. Are there any other approches that I might use
in order to use a different range? D595=d7:IV7

"JE McGimpsey" wrote:

All your ranges must be the same size.

Perhaps you could move --(D595=D7) out of the SUMPRODUCT:

=SUMPRODUCT(--(MOD(ROW(D565:D588),4)=3),
--(RIGHT(C565:C588,5)="Rec'd"), D565:D588) * (D595=D7)

In article ,
Rob wrote:

=SUMPRODUCT(--(MOD(ROW(D565:D588),4)=3),--(D595=D7),--(RIGHT(C565:C588,5)=
"Rec
'd"),D565:D588).

I have disected the fromula and applied each criteria to the range and
get
all 1' and 0's. Yet I still get a #value!. The sum range contains text
and
numeric entries, but all of the matching entries (The ones that should
add)
are numeric.
What am I missing?