Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct Question
The numbers I want to total are in Column M
=SUMPRODUCT((Data!D$1:D$2550=Lists!A13)*(Data!D$1 :D$2550<Lists!B13)*(Data!J$1:J$2550="Saint Paul")*(Data!M$1:M$25500)) What I am trying to say is- Look at the data in column D of the "Lists" worksheet. When the value of the data (this happens to be a date) is = the first day of a given year, and < the 1st day of the next year, and the city which is recorded in Column J is "Saint Paul", please total the numbers in column M. This doesn't seem to be working quite right though. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumProduct Question | Excel Worksheet Functions | |||
A SUMPRODUCT question | Excel Discussion (Misc queries) | |||
Sumproduct Question | Excel Worksheet Functions | |||
SUMPRODUCT question | Excel Worksheet Functions | |||
SUMPRODUCT Question | Excel Discussion (Misc queries) |