|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 28th, 2007, 05:23 PM
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
February 28th, 2007, 05:53 PM
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  $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
February 28th, 2007, 06:18 PM
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 $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))
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
