Calculation / Formula HELP

[Guest]

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))

 

[Guest]

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")

 

[Guest]

Your formula is missing a ")" at the end

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")