Rob,

You don't need a helper column

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rob" wrote in message
...
I thikn I can add a helper column. Thanks!

"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)="R
ec
'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?