conditional sum wizard

JBCA · 12-05-2006, 12:04 PM

Help!

In attempting first use of the conditional sum wizard, I'm getting the following message:"Your range contains one or more entries using randomized numbers. You need to remove these entries before using the wizard." The range in fact contains some values, some text and some blank cells. What does this mean?

Thanks in advance

**Glaswegian** · 12-05-2006, 04:00 PM

Hi and welcome to TSF.

Don't think I've ever used that function - I would probably just use a SUMIF formula. You could have a look at these for some hints and tips

http://sysdev.uncc.edu//HowTos/Excel...m%20Wizard.htm
http://support.microsoft.com/kb/214249

12-05-2006, 12:04 PM	#1 (permalink)
JBCA Registered User Join Date: Dec 2006 Posts: 1 OS: windows xp professional	conditional sum wizard Help! In attempting first use of the conditional sum wizard, I'm getting the following message:"Your range contains one or more entries using randomized numbers. You need to remove these entries before using the wizard." The range in fact contains some values, some text and some blank cells. What does this mean? Thanks in advance

12-05-2006, 04:00 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,482 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Hi and welcome to TSF. Don't think I've ever used that function - I would probably just use a SUMIF formula. You could have a look at these for some hints and tips http://sysdev.uncc.edu//HowTos/Excel...m%20Wizard.htm http://support.microsoft.com/kb/214249 __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner