Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with Formula
I'm trying to create a formula that sums a number of cells (in column "L") IF
the corresponding cells in column "A" are the same. For example: Company Product Value TOTAL 1 A Co. 1 100 100 2 B Co. 1 100 600 2 B Co. 2 200 3 B Co. 3 300 4 C Co. 1 100 300 5 C Co. 2 200 So, the formula should check all the cells in "Company" column and SUM the corresponding cells from the "Value" column in the "TOTAL" column. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with Formula
Try this in your TOTAL column, then copy down for all of your rows:
=IF(COUNTIF($A$1:A1,A1)=1,SUMIF($A$1:$A$100,A1,$C$ 1:$C$100),"") HTH, Elkar "1320_Life" wrote: I'm trying to create a formula that sums a number of cells (in column "L") IF the corresponding cells in column "A" are the same. For example: Company Product Value TOTAL 1 A Co. 1 100 100 2 B Co. 1 100 600 2 B Co. 2 200 3 B Co. 3 300 4 C Co. 1 100 300 5 C Co. 2 200 So, the formula should check all the cells in "Company" column and SUM the corresponding cells from the "Value" column in the "TOTAL" column. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with Formula
Worked Perfectly! Thanks!
Nate "Elkar" wrote: Try this in your TOTAL column, then copy down for all of your rows: =IF(COUNTIF($A$1:A1,A1)=1,SUMIF($A$1:$A$100,A1,$C$ 1:$C$100),"") HTH, Elkar "1320_Life" wrote: I'm trying to create a formula that sums a number of cells (in column "L") IF the corresponding cells in column "A" are the same. For example: Company Product Value TOTAL 1 A Co. 1 100 100 2 B Co. 1 100 600 2 B Co. 2 200 3 B Co. 3 300 4 C Co. 1 100 300 5 C Co. 2 200 So, the formula should check all the cells in "Company" column and SUM the corresponding cells from the "Value" column in the "TOTAL" column. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |