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
|
|||
|
|||
calculating SUM with two conditions
I have a main spreadsheet with columns as follow:
A C AT Product ID Group TOTAL BBB TOP formula ? SSS TOP CCC AAP BBB AAP And some spreadsheets with the same structure Sheet 1: A C AT Product ID Group TOTAL BBB TOP 100 SSS AAP 200 CCC AAP 100 CCC TOP 400 The same product can be for different groups. To calculate just TOTAL for Product ID without Group I’m using the following formula: =SUMIF('Sheet 1'!$A$4:$A$390,A3, 'Sheet 1'!$AY$4:$AY$390) for the spreadsheet where are only Product ID and TOTAL This formula is taking the same Product ID from the Sheet1 and calculating the SUM. It’s working well. How is it possible to take the same product and the same group from the Sheet 1 to calculate SUM? Thanks |
#2
|
|||
|
|||
You need to create an array formula. Check out Chip Pearson's site.
http://www.cpearson.com/excel/array.htm HTH, Gary Brown "Alex" wrote: I have a main spreadsheet with columns as follow: A C AT Product ID Group TOTAL BBB TOP formula ? SSS TOP CCC AAP BBB AAP And some spreadsheets with the same structure Sheet 1: A C AT Product ID Group TOTAL BBB TOP 100 SSS AAP 200 CCC AAP 100 CCC TOP 400 The same product can be for different groups. To calculate just TOTAL for Product ID without Group I’m using the following formula: =SUMIF('Sheet 1'!$A$4:$A$390,A3, 'Sheet 1'!$AY$4:$AY$390) for the spreadsheet where are only Product ID and TOTAL This formula is taking the same Product ID from the Sheet1 and calculating the SUM. It’s working well. How is it possible to take the same product and the same group from the Sheet 1 to calculate SUM? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | RICHARD | Worksheet Functions | 1 | March 15th, 2005 05:49 PM |
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | RICHARD | General Discussion | 0 | March 1st, 2005 01:53 PM |
How to multiple conditions to validate more than 2 conditions to . | Bhuvana Govind | Worksheet Functions | 1 | January 28th, 2005 07:07 PM |
return results based on multiple conditions | Drabbacs | Worksheet Functions | 3 | May 28th, 2004 11:34 PM |
Calculating Number of overdue dates with certain conditions | joannanpa | Worksheet Functions | 4 | January 19th, 2004 09:44 PM |