DB.SUM and whole cell value

's Computer Specifications

Hi,

How can I make db.sum function respect whole cell value?

Kind regards
IgorM

's Computer Specifications

On Jun 23, 2:43*am, "IgorM" <ig...@live.com> wrote:
> Hi,
>
> How can I make db.sum function respect whole cell value?
>
> Kind regards
> IgorM

Details

's Computer Specifications

example :

cells A1 to B4

Crop Area
wheat 5000
wheat for seed 3000
wheat for livestock 3000

cells A8 to B9
Crop Area sum
wheat 11000

formula in B9 is =DB.SUM(A1:B5;2;A8:A9)
And I want to be 5000 not 11000.

Uzytkownik "Don Guillett Excel MVP" <(E-Mail Removed)> napisal w
wiadomosci grup
dyskusyjnych:1c41837e-5505-44e0-bee0-(E-Mail Removed)...
> On Jun 23, 2:43 am, "IgorM" <ig...@live.com> wrote:
>> Hi,
>>
>> How can I make db.sum function respect whole cell value?
>>
>> Kind regards
>> IgorM
>
> Details
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options	Yuvraj	Microsoft Excel Misc	0	29th Jun 2009 11:20 AM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4	tviola@wi.rr.com	Microsoft Excel Programming	1	21st Aug 2008 10:13 PM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4	tviola@wi.rr.com	Microsoft Excel Worksheet Functions	0	21st Aug 2008 08:44 PM
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON	CAPTGNVR	Microsoft Excel Programming	2	8th Jul 2007 04:18 PM
How to create/run "cell A equals Cell B put Cell C info in Cell D	=?Utf-8?B?YWJtYjE2MQ==?=	Microsoft Excel Misc	5	26th Jan 2006 06:36 PM