Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation / Formula HELP
I am using the below formula to calculate the total for the subtitles listed,
now i need to add to this in order to sub total these by date as well...any help would be WONDERFUL!! (p.s. thanks to the postings i was able to use the below formula - what a life saver!!) Status $ Amount Type Date worked Processor Initials =SUMPRODUCT((E$2:E$2500="PROCESSOR")*(A$2:A$2500 = "STATUS")*(B$2:B$2500)) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation / Formula HELP
Dawn -
You may find pivot tables to be a greater time saver. Here's a great resource for learning about them http://peltiertech.com/Excel/Pivots/pivotstart.htm meanwhile, you could try =SUMPRODUCT((E$2:E$2500="PROCESSOR")*(A$2:A$2500 = "STATUS")*(B$2:B$2500)*(D$2:D$2500="2/15/2007") "Dawn" wrote: I am using the below formula to calculate the total for the subtitles listed, now i need to add to this in order to sub total these by date as well...any help would be WONDERFUL!! (p.s. thanks to the postings i was able to use the below formula - what a life saver!!) Status $ Amount Type Date worked Processor Initials =SUMPRODUCT((E$2:E$2500="PROCESSOR")*(A$2:A$2500 = "STATUS")*(B$2:B$2500)) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation / Formula HELP
Your formula is missing a ")" at the end
"Duke Carey" wrote: Dawn - You may find pivot tables to be a greater time saver. Here's a great resource for learning about them http://peltiertech.com/Excel/Pivots/pivotstart.htm meanwhile, you could try =SUMPRODUCT((E$2:E$2500="PROCESSOR")*(A$2:A$2500 = "STATUS")*(B$2:B$2500)*(D$2:D$2500="2/15/2007") "Dawn" wrote: I am using the below formula to calculate the total for the subtitles listed, now i need to add to this in order to sub total these by date as well...any help would be WONDERFUL!! (p.s. thanks to the postings i was able to use the below formula - what a life saver!!) Status $ Amount Type Date worked Processor Initials =SUMPRODUCT((E$2:E$2500="PROCESSOR")*(A$2:A$2500 = "STATUS")*(B$2:B$2500)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changes to Calculation Formula | New Users to Excel | |||
Calculation vs formula | Excel Worksheet Functions | |||
formula calculation | Excel Discussion (Misc queries) | |||
calculation in an if formula | Excel Worksheet Functions | |||
i need help with a calculation formula... | Excel Worksheet Functions |