syed_mushraf
Active Member
- Joined
- Oct 13, 2002
- Messages
- 261
cell Sheet1!A1 to Sheet1!G1 is merged cell with heading "Week-1"
cell Sheet1!A2 to Sheet1!G2 have some data
Cell Sheet1!H1 to Sheet1!N1 is merged cell for heading "Week-2"
cell Sheet1!H2 to Sheet1!G2 have some data
----------------------------------------------------
I need a summary in the sheet!2 by using sumif function
Cell Sheet2!A1 is containing "Week-1"
in Shee2!A2 i need sum of Sheet1!A2:G2 using Sumif "Week-1"
Plz help how will be done
cell Sheet1!A2 to Sheet1!G2 have some data
Cell Sheet1!H1 to Sheet1!N1 is merged cell for heading "Week-2"
cell Sheet1!H2 to Sheet1!G2 have some data
----------------------------------------------------
I need a summary in the sheet!2 by using sumif function
Cell Sheet2!A1 is containing "Week-1"
in Shee2!A2 i need sum of Sheet1!A2:G2 using Sumif "Week-1"
Plz help how will be done