View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dawn Dawn is offline
external usenet poster
 
Posts: 80
Default 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))