hardeep
07-09-2009, 12:42 AM
Dear Expert
Attached in the copy of my question.I Want to Merge the Data in Column D and Column E based on column A & Column B.:banghead:
Basically, In Column A i have Company Names, Column B have there City Names, and Column C have there Total.
Now in column D i want the Sum of Column C. Now, i am using this
IF(OR($A2<>$A1,$B2<>$B1),SUMPRODUCT(--($A$2:$A$33=$A2),--($B$2:$B$33=$B2),($C$2:$C$33)),""):doh:
Which is Perfect.
And in Column E i want the Average of Column D, Now i am using this
D2/SUMPRODUCT(--($A$2:$A$33=A2),--($B$2:$B$33=B2)):doh:
Which is also Perfect.
For better Clarity See the Attached.
Kindly, see the Second file " I want This"
Thanks in Advance
Hardeep Kanwar
Attached in the copy of my question.I Want to Merge the Data in Column D and Column E based on column A & Column B.:banghead:
Basically, In Column A i have Company Names, Column B have there City Names, and Column C have there Total.
Now in column D i want the Sum of Column C. Now, i am using this
IF(OR($A2<>$A1,$B2<>$B1),SUMPRODUCT(--($A$2:$A$33=$A2),--($B$2:$B$33=$B2),($C$2:$C$33)),""):doh:
Which is Perfect.
And in Column E i want the Average of Column D, Now i am using this
D2/SUMPRODUCT(--($A$2:$A$33=A2),--($B$2:$B$33=B2)):doh:
Which is also Perfect.
For better Clarity See the Attached.
Kindly, see the Second file " I want This"
Thanks in Advance
Hardeep Kanwar