Hi,Dear All,Can anyone please help me out with this ?? its urjent .. if possible
i have reports in one sheet and and i want to count datas as per city with date data count exactly...
i have attached a sample file for same..
please help...
Hi Jitendra,
See the attached file, with Pivot Table on Sheet4.
Regards,
Hi,
Have a look at your workbook. The formula is this
=SUMPRODUCT((Sheet2!$B$1:$JK$1=B2& " Sale")*(Sheet2!$A$2:$A$6=A2)*(Sheet2!$B$2:$JK$6))
hi mike,
u are brilliant,,, thanks a lot for help...
Hi,but in this i also want to date wise data which is showing in somedra sir table what happend with this formula when i add more dates...
Hi,
No problem, this now does up to 5000 rows
=SUMPRODUCT((Sheet2!$B$1:$JK$1=B2& " Sale")*(Sheet2!$A$2:$A$5000=A2)*(Sheet2!$B$2:$JK$5000))
I you want even more then change the 5000 in bold (2 places) to a larger number, the only rule is the numbers must be the same.
Hi Jitendra,
See the attached file, with Pivot Table on Sheet4.
Regards,
I did not got your point, Pivot table automatically update results, as the data changes, you just need to refresh them.if its give me correct result then no -problem with me but its absolutly i want to type manually all results with that data..
Well I Still don't understand what are you looking at. See the file.
Regards,
thank you for ur time sir, here isCan you post a sample file with at least 5 dates of data with 10 cities with output required.
Regards,
sir i am little bit confused where you have applied PT and how...See the file, Sheet4.
Regards,
PT is on sheet4, click on any one cell you will see the field list which will show you where to put what.
Regards,