|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 14th, 2010, 09:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
March 14th, 2010, 09:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
March 15th, 2010, 12:19 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summarizing up cells based on two different criterias
Excel 2007 PivotTable
http://www.mediafire.com/file/jy2imk...03_14_10a.xlsx Pdf preview: http://www.mediafire.com/file/czmtwcqmgw5/03_14_10a.pdf
|
|
#4
March 15th, 2010, 02:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summarizing up cells based on two different criterias
Dear Herbert,
Maz I ask you to provide me with the same file but in preious versions of Excel (i.e. in .xls format not in . xlsx) Thank you in advance, Ruslan "Herbert Seidenberg" wrote: Excel 2007 PivotTable http://www.mediafire.com/file/jy2imk...03_14_10a.xlsx Pdf preview: http://www.mediafire.com/file/czmtwcqmgw5/03_14_10a.pdf .
|
|
#5
March 15th, 2010, 02:58 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summarizing up cells based on two different criterias
You could try this:
http://support.microsoft.com/kb/923505/en-us Ruslan wrote: Dear Herbert, Maz I ask you to provide me with the same file but in preious versions of Excel (i.e. in .xls format not in . xlsx) Thank you in advance, Ruslan "Herbert Seidenberg" wrote: Excel 2007 PivotTable http://www.mediafire.com/file/jy2imk...03_14_10a.xlsx Pdf preview: http://www.mediafire.com/file/czmtwcqmgw5/03_14_10a.pdf .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
