Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condition Sum
Hello, I need a formula to sum Column C when the data across Columns E, F and G haven't already appeared. In other words, if the data across Columns E, F and G is listed more than once, Column C is counted once only. C 100 300 300 200 400 400 100 E A B B A X X Y F 1111000000 4400111111 4400111111 1111000000 4611000000 4611000000 1515000000 G 02-Jan-06 02-Jan-06 02-Jan-06 07-Jan-06 22-Jan-06 22-Jan-06 31-Jan-06 Thank for your help, Gos-C -- Gos-C ------------------------------------------------------------------------ Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518 View this thread: http://www.excelforum.com/showthread...hreadid=513434 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condition Sum
If I understand you correctly, you want to sum column c on 3 separate occasions - in column e, f and g. In each of these three columns you want to sum column c only if data in the active column is not duplicated. ie column e would sum only on the first instance of the character appearing in that column. A, B, X and Y. "Gos-C" wrote: Hello, I need a formula to sum Column C when the data across Columns E, F and G haven't already appeared. In other words, if the data across Columns E, F and G is listed more than once, Column C is counted once only. C 100 300 300 200 400 400 100 E A B B A X X Y F 1111000000 4400111111 4400111111 1111000000 4611000000 4611000000 1515000000 G 02-Jan-06 02-Jan-06 02-Jan-06 07-Jan-06 22-Jan-06 22-Jan-06 31-Jan-06 Thank for your help, Gos-C -- Gos-C ------------------------------------------------------------------------ Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518 View this thread: http://www.excelforum.com/showthread...hreadid=513434 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condition Sum
Rows 2 and 3 are the same, and rows 5 and 6 are the same. Therefore, we are summing rows 1, 2, 4, 5 and 7. We are not summing duplicates. Gos-C -- Gos-C ------------------------------------------------------------------------ Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518 View this thread: http://www.excelforum.com/showthread...hreadid=513434 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condition Sum
hi! assuming your data in A1:D7 use Advance Filer list range "A1:D7" criteria range -leave blank- check "Unique Records only" check "copy to other location" range "of your wish" the uniqe records will be copied down to a new location. use "auto sum" -via135 Gos-C Wrote: Rows 2 and 3 are the same, and rows 5 and 6 are the same. Therefore, we are summing rows 1, 2, 4, 5 and 7. We are not summing duplicates. Gos-C -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=513434 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep cell blank if condition is false in IF function | Excel Discussion (Misc queries) | |||
conditional formatting - multiple condition | Excel Discussion (Misc queries) | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Condition IF | Excel Discussion (Misc queries) | |||
Add condition to formula | Excel Worksheet Functions |