Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Masters,
An body can help me for using sumproduct() per each group. for example | A B C ------------- 1| P 2 14 2| 5 3| 7 4| 5| P 3 7 6| 1 7| 1 8| 2 want result in column C1 and C5 is automatically if I sort in column A equal P, and using some formula in C1 and C5 Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Under data/Group&outline/group | Excel Discussion (Misc queries) | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |