Hi:
Please open the attached excel file for referance.
Go to Sheet1
I have Sheets named 505,512,519,526,602.
In this sheets
Column A : Account ID
Column C : # Of Record
Column D : # of Full Billable
etc
Based on the Catagory you select from drop down list in cell A1, i need the sheet data transfered
to Sheet1.
I tried using SUMPRODUCT, SUMIF function but failed.
=SUM(IF('505'!$A$2:'505'!$A$350=A6,IF('505'!$C$1=$A$2,'505'!$C$2:'505'!$C$350,0),0))
Please help me with this.
Thanks a lot
Riz
Bookmarks