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