LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Summarizing up cells based on two different criterias

Dear All,
I have the following table:
No. Hours Price/m² Price/hr Total price Total m²
20140 8,50 0,08 20 170,00 ‚¬ 2125,00
20140 9,15 0,08 20 183,00 ‚¬ 2287,50
20140 6,00 0,85 20 120,00 ‚¬ 141,18
20140 8,50 0,85 20 170,00 ‚¬ 200,00
20170 8,00 0,08 20 160,00 ‚¬ 2000,00
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:
No. Total m² Price/m² Total price
20140 4412,50 0,80 ‚¬ 353,00 ‚¬
20140 341,18 0,85 ‚¬ 290,00 ‚¬
20170 2000,00 0,80 ‚¬ 160,00 ‚¬
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!
Rgd,
Ruslan
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add data from cells based on different criterias? Peter Gonzalez[_2_] Excel Worksheet Functions 2 February 6th 10 03:50 PM
sum based on 4 criterias freebee Excel Discussion (Misc queries) 4 June 28th 09 03:38 AM
Insert values based on 2 criterias wamz Excel Discussion (Misc queries) 3 September 14th 07 12:02 PM
Counting instances based on two criterias [email protected] Excel Worksheet Functions 7 June 5th 06 07:18 PM
Summarizing data based on ID Giz Excel Worksheet Functions 8 December 20th 05 07:23 PM


All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"