Remember Me?

#1
November 20th 05, 10:01 PM posted to microsoft.public.excel.worksheet.functions
 Steved Posts: n/a
Showing #VALUE!

Hello from Steved

The below is Showing #VALUE! What is required please to show a blank Cell.

{=SUMPRODUCT(--(CityPanmureDepots!\$A\$24=\$A\$23),CityPanmureDepots! \$G\$24)}

Thankyou.

#2
November 20th 05, 10:18 PM posted to microsoft.public.excel.worksheet.functions
 Bruno Campanini Posts: n/a
Showing #VALUE!

"Steved" wrote in message
...
Hello from Steved

The below is Showing #VALUE! What is required please to show a blank Cell.

{=SUMPRODUCT(--(CityPanmureDepots!\$A\$24=\$A\$23),CityPanmureDepots! \$G\$24)}

CityPanmureDepots!\$G\$24 to be Numeric!
Then you can have 0.
You can't have any blank as a result from SUMPRODUCT().

Bruno

#3
November 20th 05, 10:33 PM posted to microsoft.public.excel.worksheet.functions
 Steved Posts: n/a
Showing #VALUE!

Thanks Bruno

Yes I thought this may be the answer but was not to sure.

"Bruno Campanini" wrote:

"Steved" wrote in message
...
Hello from Steved

The below is Showing #VALUE! What is required please to show a blank Cell.

{=SUMPRODUCT(--(CityPanmureDepots!\$A\$24=\$A\$23),CityPanmureDepots! \$G\$24)}

CityPanmureDepots!\$G\$24 to be Numeric!
Then you can have 0.
You can't have any blank as a result from SUMPRODUCT().

Bruno

#4
November 20th 05, 10:44 PM posted to microsoft.public.excel.worksheet.functions
 Bob Phillips Posts: n/a
Showing #VALUE!

SUMPRODUCT is not an array formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steved" wrote in message
...
Hello from Steved

The below is Showing #VALUE! What is required please to show a blank Cell.

{=SUMPRODUCT(--(CityPanmureDepots!\$A\$24=\$A\$23),CityPanmureDepots! \$G\$24)}

Thankyou.

#5
November 20th 05, 10:45 PM posted to microsoft.public.excel.worksheet.functions
 Ron Rosenfeld Posts: n/a
Showing #VALUE!

On Sun, 20 Nov 2005 14:01:01 -0800, Steved
wrote:

Hello from Steved

The below is Showing #VALUE! What is required please to show a blank Cell.

{=SUMPRODUCT(--(CityPanmureDepots!\$A\$24=\$A\$23),CityPanmureDepots! \$G\$24)}

Thankyou.

=IF(ISNUMBER(CityPanmureDepots!\$G\$24),SUMPRODUCT(--(CityPanmureDepots!\$A\$24=\$A\$23),CityPanmureDepots! \$G\$24),"")

--ron

#6
November 20th 05, 10:48 PM posted to microsoft.public.excel.worksheet.functions
 Peo Sjoblom Posts: n/a
Showing #VALUE!

I don't think you need sumproduct in this case

=IF(A24=A23,G24,"")

(put in the sheet names)

in case you need sumproduct you can use a custom format like
General;-General;;
it will not show zero

--
Regards,

Peo Sjoblom

"Steved" wrote in message
...
Thanks Bruno

Yes I thought this may be the answer but was not to sure.

"Bruno Campanini" wrote:

"Steved" wrote in message
...
Hello from Steved

The below is Showing #VALUE! What is required please to show a blank
Cell.

{=SUMPRODUCT(--(CityPanmureDepots!\$A\$24=\$A\$23),CityPanmureDepots! \$G\$24)}

CityPanmureDepots!\$G\$24 to be Numeric!
Then you can have 0.
You can't have any blank as a result from SUMPRODUCT().

Bruno

#7
November 22nd 05, 10:08 PM posted to microsoft.public.excel.worksheet.functions
 Steved Posts: n/a
Showing #VALUE!

Thankyou all

"Ron Rosenfeld" wrote:

On Sun, 20 Nov 2005 14:01:01 -0800, Steved
wrote:

Hello from Steved

The below is Showing #VALUE! What is required please to show a blank Cell.

{=SUMPRODUCT(--(CityPanmureDepots!\$A\$24=\$A\$23),CityPanmureDepots! \$G\$24)}

Thankyou.

=IF(ISNUMBER(CityPanmureDepots!\$G\$24),SUMPRODUCT(--(CityPanmureDepots!\$A\$24=\$A\$23),CityPanmureDepots! \$G\$24),"")

--ron

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

 Similar Threads Thread Thread Starter Forum Replies Last Post Lee Excel Discussion (Misc queries) 1 October 26th 05 03:16 PM Ask Excel Discussion (Misc queries) 1 July 20th 05 04:20 PM EaglesNest Excel Discussion (Misc queries) 4 March 26th 05 05:21 PM Leolin Excel Worksheet Functions 8 March 18th 05 05:36 PM smboyd Charts and Charting in Excel 1 February 1st 05 09:53 PM

All times are GMT +1. The time now is 03:13 PM.