Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a subtotal for 5 different products in a table
Column A will have 5 different colors (Blue, Green, Red, Black) Column L has a price/rate Column O - R have Quantity for each week (total of 4) I need to have subtotals for each color for each week. A L O P Q R Blue 290 5 5 5 0 Green 190 5 5 5 5 Red 0 6 6 6 6 Green 10 10 10 10 10 Green 190 0 0 0 8 Black 20 5 5 5 5 From the example above I need subtotals for each color by week. Any way to get this done with Sumproduct or sumif? Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct and sumif | Excel Worksheet Functions | |||
SumIf or SumProduct | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumif or Sumproduct? Maybe neither? | Excel Worksheet Functions | |||
sumif or sumproduct | Excel Worksheet Functions |