Advertisement

05.30.2008 at 09:42AM PDT, ID: 23445175
[x]
Attachment Details

Help with Excel Sums

Asked by Simonrepro in Microsoft Excel Spreadsheet Software

Tags: , , ,

The sum below does all numbers between 40001 and 40006, how do I do the sum 40001 to 40006 + 40008 to 40009 please?

=SUMPRODUCT(('Trial Balance'!$A$2:$A$1052>="40001")*('Trial Balance'!$A$2:$A$1052<="40006")*'Trial Balance'!C$2:C$1052)Start Free Trial
 
Keywords: Help with Excel Sums
Title
1 I need help with a sum in Excel
2 SUMPRODUCT??
3 SUM VALUES BASED ON SELECTION …
4 SUM time in Excel
5 sum(conf)
6 Using an 'IF' in a sum
 
Loading Advertisement...
 
[+][-]05.30.2008 at 09:45AM PDT, ID: 21679388

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.30.2008 at 12:59PM PDT, ID: 21680955

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: Microsoft, Excel, XP, Sums
Sign Up Now!
Solution Provided By: Bert01
Participating Experts: 2
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628