Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The case is I want to key in two criteria and the function give me back the
total. For example, I want Sun in the rows and Two in the column, then will give me the total of 2 + 8 = 10. The Sun and the Two is input some where and will be change from time to time. A B C D 1 One Two Three 2 Sun 1 2 3 3 Mon 4 5 6 4 Sun 7 8 9 I tried using SUMPRODUCT but did not seem to work, may be due to my knowledge is not good enough, anyone know how or have other functions that make it work? Thanks very much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matrix | Excel Worksheet Functions | |||
Matrix | Excel Discussion (Misc queries) | |||
Matrix multiplication using sumproduct | Excel Worksheet Functions | |||
Matrix | Excel Discussion (Misc queries) | |||
BCG matrix | Charts and Charting in Excel |