Re: calculations

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 10/04/04 

Date: Mon, 4 Oct 2004 16:44:07 +0200

Hi
for automating this process try:
- select column A
- hit F5 and click 'Special'
- choose 'Empty cells'
- enter the equation sign '=' and hit the upper arrow key
- now commit the entry with CTRL+ENTER 

-- 
Regards
Frank Kabel
Frankfurt, Germany
anonymous@discussions.microsoft.com wrote:
> I want to avoid manually filling in the rows.  I would
> like to do either of 2 things.
> 
> 1.  Automate the process of filling in the Dept if the
> field below is empty or
> 2.  For a particular amount, go left, get Paytype and then
> left to get dept, if dept field is empty, go up until you
> come accross a value.
> 
> Thanks
>> -----Original Message-----
>> Hi
>> could you fill column A in all rows with the dep. ID this way you
>> could use SUMPRODUCT for this. See:
>> http://www.xldynamic.com/source/xld.SUMPRODUCT.html
>> 
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>> 
>> 
>> anonymous@discussions.microsoft.com wrote:
>>> I have a file like
>>> 
>>> Dept   PayType   Amount
>>> 2312    OT         500
>>>         reg       1000
>>>         vac         10
>>>         ss           5
>>> 2566    ot        5522
>>>         reg         42
>>>         vac        565 etc
>>> 2556    reg         10
>>> I would like to automate the process of cumulating the
>>> amounts.  For eg: I need to sum "reg" and "ot"
> for "2312"
>>> and "2556" only.  I think the logic should go something
>>> like this - look in paytype and find "reg" or "ot", if
>>> found, move left and if dept is "blank", go up until you
>>> get a value.  Now, if that is "2312" or "2556",
>>> sum"amount".
>>> 
>>> I am lost coding this.  please help
>>> Thanks
>>> .
>> 
>> .