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?
|