Calculation / Formula HELP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dawn - 28 Feb 2007 17:23 GMT

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 to this Message

Duke Carey - 28 Feb 2007 17:53 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> =SUMPRODUCT((E$2:E$2500="PROCESSOR")*(A$2:A$2500 = "STATUS")*(B$2:B$2500))

Reply to this Message

Teethless mama - 28 Feb 2007 18:18 GMT

Your formula is missing a ")" at the end

> Dawn -
>
[quoted text clipped - 16 lines]
> >
> > =SUMPRODUCT((E$2:E$2500="PROCESSOR")*(A$2:A$2500 = "STATUS")*(B$2:B$2500))

Reply to this Message