View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ruslan Ruslan is offline
external usenet poster
 
Posts: 12
Default Summarizing up cells based on two different criterias

Dear All,
I have the following table:
A B C D E F
1 No. Hours Price/mツイ Price/hr Total price Total mツイ
2 20140 8,50 0,08 20 170,00 ぎ 2125,00
3 20140 9,15 0,08 20 183,00 ぎ 2287,50
4 20140 6,00 0,85 20 120,00 ぎ 141,18
5 20140 8,50 0,85 20 170,00 ぎ 200,00
6 20170 8,00 0,08 20 160,00 ぎ 2000,00
7 20170 8,50 0,85 20 170,00 ぎ 200,00

And I need to get automatically report which will sum up "Total mツイ" and
"Total price" of those with the same "No." and the same "Price/mツイ".
In other words the report must look like the following:

A B C E
1 No. Total mツイ Price/mツイ Total price
2 20140 4412,50 0,08 353,00 ぎ
4 20140 341,18 0,85 290,00 ぎ
6 20170 2000,00 0,08 160,00 ぎ
7 20170 200,00 0,85 170,00 ぎ

I was able to sum up bz using just one criteria "No." but when it comes to
two criterias I failed.
I'd greatly appreciate zour help!
Rgds,
Ruslan