Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a table where 1st column has the store names and the 1st row has items
(for some reason they are not unique). For example: Sales RetailExpense StockLoss RetailExpense GrossMargin Dahua 120 -5 -20 -12 20 Hebin 100 -15 -10 -12 16 HuZhou 130 -19 -10 -20 16 Wuxi 100 -29 -15 -17 18 Jinhua 160 -19 -10 -20 16 Then I have to create summaries by stores. I need a formula in each by-store sheet to sum the numbers that meet both the row and the column conditions. eg. a particular store (it's changing sheet by sheet but always has the name in cell J1)'s total retail expenses. I hope this is clear. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum a range if two conditions are met | Excel Discussion (Misc queries) | |||
Sum within a date range meeting one other criteria | Excel Worksheet Functions | |||
using sumproduct on subtotals meeting certain conditions | Excel Worksheet Functions | |||
Average of numbers within a range meeting certain criteria | Excel Worksheet Functions | |||
Meeting two conditions before summing | Excel Worksheet Functions |