Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advenced filter (yardım)
2 kolonu advenced filter ile filtreliyom
fakat ikinci kolon filtrelenirken SUM yapılmasını istiyom nasıl yaparım |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advenced filter (yardım)
emrullah wrote: 2 kolonu advenced filter ile filtreliyom fakat ikinci kolon filtrelenirken SUM yapılmasını istiyom nasıl yaparım Advanced Filter cannot sum... Let A1:B10 house: X,Y Cebe,6 Korkut,7 Deniz,10 Cebe,5 Demir,8 Deniz,2 Turgut,10 Cebe,4 Korkut,1 Apply Advanced Filter on X such that you get in D from D1 on: X Cebe Korkut Deniz Demir Turgut In E2 enter & copy down: =SUMIF($A$2:$A$10,D2,$B$2:$B$10) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advenced filter (yardım)
"emrullah": 2 kolonu advenced filter ile filtreliyom fakat ikinci kolon filtrelenirken SUM yapılmasını istiyom nasıl yaparım abi çok sağol ama asıl problem A B C 111 168 1.250 111 168 2.500 112 168 3.250 112 168 5.250 113 169 8.200 120 170 1000 120 170 3000 120 170 6000 120 170 4000 bunu aşağıdaki hale getircek A B C 111 168 3.750 112 168 8.500 113 169 8.200 120 170 14000 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advenced filter (yardım)
Assuming that the sample is in A2:C10, add labels before the first
record, e.g., X, Y, and Z. Apply Advanced Filter on A:B with the Unique records only option checked such that: X Y 111 168 112 168 113 169 120 170 appears in D1:E5. In F2 enter & copy down: =SUMPRODUCT(--($A$2:$A$10=D2),--($B$2:$B$10=E2),$C$2:$C$10) This setup does not replace the original data if that's what you have in mind. emrullah wrote: "emrullah": 2 kolonu advenced filter ile filtreliyom fakat ikinci kolon filtrelenirken SUM yapılmasını istiyom nasıl yaparım abi çok sağol ama asıl problem A B C 111 168 1.250 111 168 2.500 112 168 3.250 112 168 5.250 113 169 8.200 120 170 1000 120 170 3000 120 170 6000 120 170 4000 bunu aşağıdaki hale getircek A B C 111 168 3.750 112 168 8.500 113 169 8.200 120 170 14000 -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The filter didn't show all (2,254) names when I set it up | Excel Discussion (Misc queries) | |||
How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |