Thread
:
SUMPRODUCT throwing a #VALUE error when using range instead of single cell
View Single Post
#
2
Posted to microsoft.public.excel.programming
Claus Busch
external usenet poster
Posts: 3,872
SUMPRODUCT throwing a #VALUE error when using range instead of single cell
Hi Pete,
Am Wed, 30 Dec 2015 08:53:52 -0800 (PST) schrieb
:
=SUMPRODUCT(1*(OR(AND(ISTEXT(Standard4[Debit]),LEN(TRIM(Standard4[Debit]))0),LEN(LEFT(Standard4[Debit],FIND(".",Standard4[Debit]&".")-1))13)))
try:
=SUMPRODUCT(--(LEN(TRIM(L1:L1000))0)*(L1:L1000=1000000000000))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch