| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum Product Help Needed
Hi
I am trying to use SUMPRODUCT to sum the values of a list by 2 conditions. The list has a date column and a Category column and in my summary table i would like to summarise all entries by date and column Category is held in Summary!A3 and month is held in Summary!B1. Can anyone point out where i am going wrong? TIA =SUMPRODUCT(Expenditure!$C$2:$C$100=Summary!A3)*MO NTH(Expenditure!$A$2:$A$100=MONTH(Summary!$B$1)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which Function(s) do I use? | Excel Worksheet Functions | |||
| product sum per month per customer | Excel Worksheet Functions | |||
| exxcel product activation.... | Excel Discussion (Misc queries) | |||
| my computor crashed and I lost my product code to reinstall how c. | Excel Discussion (Misc queries) | |||
| If statement needed | Excel Worksheet Functions | |||
Threaded Mode
