Hi Vaibhav & Paul,
Thanks a lot for your HELP.
On Mon, Jul 21, 2014 at 6:18 PM, Vaibhav Joshi wrote:
> see this...
>
> Cheers!!
>
>
> On Mon, Jul 21, 2014 at 5:53 PM, Dileep Kumar wrote:
>
>> Hi Vaibhav,
>>
>> Thanks a lot for your reply. I found that what mistake I am doing.
>>
>> Is there a
can,
>In all the ways you can,
>In all the places you can,
>At all the times you can,
>To all the people you can,
>As long as ever you can.” - John Wesley
>-------------
>
>
> From: Paul Schreiner
>>To: "excel-macros@googlegroups.com&
>To: "excel-macros@googlegroups.com"
>Sent: Monday, July 21, 2014 8:35 AM
>Subject: Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please
>Help
>
>
>
> For your sumif(Indirect function in cell B5, try:
>
>=SUMIF(INDIRECT("'"
For your sumif(Indirect function in cell B5, try:
=SUMIF(INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!C18:C40"),B$3,INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!F18:F40"))
(It should copy to D, F, H, J also)
Paul
-
“Do all the good you can,
By all the means you can,
Hi Vaibhav,
Thanks a lot for your reply. I found that what mistake I am doing.
Is there any way that we can give the reference of the date field in the
summary sheet science I have all the sheet with dates only.
That can much faster for me to finish out.
On Mon, Jul 21, 2014 at 5:45 PM, Vaibh
what you are trying to achieve?
On Mon, Jul 21, 2014 at 5:12 PM, Dileep Kumar wrote:
> Dear Friends,
>
> Please find attached Daily Reporting Formate of Excel in the summary sheet
> I am unable to get the vales using indirect function.
>
> Please help me friends.
>
> --
> Regards,
> Dileep Kuma
