hi Max
It Still show #VALUE! error
RKS
"Max" wrote:
Try wrap a TRIM around the text range for improved robustness:
=SUMPRODUCT(--(TRIM($A$3:$A$5)="RED"),$B$3:$B$5*$F$3:$F$5)
P/s: Pl press the YES buttons (like the one below) for ALL responses which
help to answer your query
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"RKS" wrote:
Hi Max
Thanks for reply
its working in new sheet. but not working my sheet. i think my column f hv
some blank and some place in character. pls advice me or change ur formula so
its working both condition