Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

SUMPRODUCT with text cells, returns #VALUE

Hi Gijs,

Am Fri, 7 Jul 2017 08:33:37 +0100 schrieb GijsKijlstra:

It works like a charm! Herzlichen dank

you are welcome.

Without array:
=SUMPRODUCT((($A$3:$A$93=$M$107)+ISNUMBER($Q$3:$Q$ 93)),$I$3:$I$93,$Q$3:$Q$93)

Regards
Claus B.
--
Windows10
Office 2016

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMPRODUCT returns !Value#	Dana	Excel Worksheet Functions	5	November 17th 08 07:04 PM
Min Sumproduct formula returns a zero.	checkQ	Excel Discussion (Misc queries)	2	May 10th 08 08:06 PM
Sumproduct with text and numbers in cells	Lee	New Users to Excel	10	April 21st 08 04:18 PM
SumProduct Returns Zero	ronnomad	Excel Worksheet Functions	4	August 10th 06 02:45 PM
sumproduct returns zero	vacation	Excel Worksheet Functions	7	January 31st 06 07:56 PM

All times are GMT +1. The time now is 11:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us