Dear De Premor & Ravinder Sir,
Thanks for your help and valuable support. Thanks a lot.
Thanks,
Ashish Kumar
On Saturday, September 7, 2013 11:32:20 AM UTC+5:30, De Premor wrote:
>
> The good thing is that your sheet name have a same name with what we are
> looking for also the name of month,
The good thing is that your sheet name have a same name with what we are
looking for also the name of month, so we can process it easily, try
this on B2
=COUNTA(OFFSET(INDIRECT($A2&"!$A1"
),2,MATCH(B$1,INDIRECT($A2&"!$1:$1"),0)-1,2^16))
On 07-09-2013 12:43, Ashish Kumar wrote:
Dear Seniors,
Dear Senior,
All data in single workbook in different sheets and i want to create a
summary in output sheet. Data pattern will be same according to the sheet
which i'hve attached for query reference.
Thanks,
Ashish
On Saturday, September 7, 2013 11:22:03 AM UTC+5:30, Excel Group wrote:
>
> Hi
Hi Ashish,
Please confirm that the all data in a single sheet or in different
different sheets.
On Sat, Sep 7, 2013 at 11:13 AM, Ashish Kumar wrote:
> Dear Seniors,
>
>
> I want total count of Sold Items according to the state or months. I'hve
> tried this through Counta formula but this is h
