try this formula or attached file
=IFERROR(INDIRECT("d"&SMALL(IF(IF(COUNTIF($E$3:$E$5,$D$3:$D$8)=0,1,0)*ROW($D$3:$D$8)>0,ROW($D$3:$D$8)),ROW(A1))),"")
From: santosh subudhi
To: excel-macros
Sent: Thursday, August 22, 2013 4:55 AM
Subject: $$Excel-Macros$$ Ex
dear sir formula not work plz help.
On Aug 22, 2013 5:34 PM, "Ali Abbas" wrote:
> thanks brother
> On Aug 22, 2013 4:14 PM, wrote:
>
>> **
>> You can use sumproduct also
>>
>> =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b)
>>
>> Assuming dates are in a row , amount are in b row. C1=smaller cutoff
De Promor,
Could you please check that code by giving hadcoded values in the fomula?
like xsum ( 1,2,3). it is not working. i want to have a function which
works eighther for range and for range and for both. Thanks for your work
on this.
-Pavan
On Thu, Aug 22, 2013 at 6:15 PM, De Premor wrote
Thank a lot
Your code works fine
Kind regards
Peter
2013/8/22 De Premor
> try this code
>
> Sub sort()
> Dim Str() As String
> Str = Split([G4], ":")
> With ActiveSheet.sort
> .SortFields.Add Key:=Range(Str(0))
> .SetRange Range([G4])
> .Apply
> End W
Hi Ali,
We can use Sumifs or Sumproduct
=SUMPRODUCT(($B$1:$B$27>=41317)*($B$1:$B$27<=41325),$A$1:$A$27)
=SUMIFS($A$1:$A$27,$B$1:$B$27,">="&41317,$B$1:$B$27,"<="&41325)
.
Enjoy
Team XLS
On Thu, Aug 22, 2013 at 8:33 PM, Ali Abbas wrote:
> Dear all. How can we calcula
thanks brother
On Aug 22, 2013 4:14 PM, wrote:
> **
> You can use sumproduct also
>
> =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b)
>
> Assuming dates are in a row , amount are in b row. C1=smaller cutoff date
> and c2=latest date .
>
> Hope it works for you! :)
> Sandeep
> Sent on my BlackBerry®
You can use sumproduct also
=sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b)
Assuming dates are in a row , amount are in b row. C1=smaller cutoff date and
c2=latest date .
Hope it works for you! :)
Sandeep
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Ali Abbas
Sender:
Date: 1 2 3 4
Amount: 100 200 300 400
Now formula working.
We can calculate value with array sum amount if date 1 to 3 then answer is
600 but if we change date scenario and mention date in cut day like sum
amount if date is 2 to 4 then its answer will be 900 but how can I make
th
Dear all. How can we calculate a array function for sum amount or any
figure for cut dates like sum if( 12 feb to 20 feb)
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discu
Try this and explore it
Function xSum(ParamArray Numbers()) As Variant
Dim BlockRange, SingleRange, Buffer
For Each BlockRange In Numbers
For Each SingleRange In BlockRange
Buffer = Buffer + SingleRange
Next
Next
xSum = Buffer
End Function
Pada 22/08/
try this code
Sub sort()
Dim Str() As String
Str = Split([G4], ":")
With ActiveSheet.sort
.SortFields.Add Key:=Range(Str(0))
.SetRange Range([G4])
.Apply
End With
End Sub
Pada 22/08/2013 18:39, Pekon menulis:
Dear experts
I hope that you can help me.
I
Hi Guys, Hope all are doing well.
Here comes the subject. I am trying to get the code behing sum function. I
searched for the but all went vain.
I tried using Paramarray but it is not working when we are refering to a
paraticular range. i want to write a function which really works like sum
fu
Dear Santosh,
PFA solution of your problem.
Regards
Deepak
On Thu, Aug 22, 2013 at 2:16 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi Anil,
>
> Thanks for your prompt reply.
>
> However the solution did't solve my problem.
>
> I have attached the solution sheet with desire
Dear experts
I hope that you can help me.
In the attachment you will find an example file. I try to to sort a part of
the worksheet with a macro.
For some reason I cannot use a refer to cell G4 (with the range of the
table to be sorted) in the macro.
Who can give me the right code?
Kind Re
Hi Anil,
Thanks for your prompt reply.
However the solution did't solve my problem.
I have attached the solution sheet with desired result.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
Date: Thu, 22 Aug 2013 09:58:48 +0530
> Subject: Re: $$Excel-Macros$$ Extract Names which are not commo
thanx Anil :)
On Thu, Aug 22, 2013 at 12:05 PM, अनिल नारायण गवली
wrote:
> Dear Waseem,
>
> Mostly font color should be black and cell color should be red for
> negative.
> positive:- font color should be black and cell color should be gree.
>
>
> Warm Regards,
> Gawli Anil.
> Thanks & Regards,
16 matches
Mail list logo