This seems to be missing your text, Kumar. :(
From: Kumar Punnam
To: excel-macros@googlegroups.com
Sent: Thu, August 5, 2010 6:29:35 AM
Subject: Re: $$Excel-Macros$$ Sumproduct with 3 criteria +
On Tue, Aug 3, 2010 at 5:54 PM, Nadine S wrote:
Let me try
adine
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Thu, August 5, 2010 4:53:35 AM
Subject: RE: $$Excel-Macros$$ Sumproduct with 3 criteria +
Hi Nadine,
Sorry I haven't got back to you on this. And I don't even know if it has been
answere
his
> computer.
>
> Thanks so much.
>
> --
> *From:* Dave Bonallack
> *To:* "excel-macros@googlegroups.com"
> *Sent:* Tue, August 3, 2010 2:40:30 AM
> *Subject:* RE: $$Excel-Macros$$ Sumproduct with 3 criteria +
>
> Hi Nadine,
> I'm guessing a bit.
>
&
l, which I don't see how you can sum. Sorry I'm not understanding.
Regards - Dave.
Date: Tue, 3 Aug 2010 05:24:47 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Sumproduct with 3 criteria +
To: excel-macros@googlegroups.com
Let me try this again.
Sheet 1 ha
ooglegroups.com"
Sent: Tue, August 3, 2010 2:40:30 AM
Subject: RE: $$Excel-Macros$$ Sumproduct with 3 criteria +
Hi Nadine,
I'm guessing a bit.
"What I need is a total of the result of that"
I assume this means the result of your SumProduct formula
"plus the same if it = $R$
u
want the result of the SumProduct formula x 2
Is that it?
Also, can you tell me the name of the sheet where the SumProduct actually
resides?
Regards - Dave.
Date: Mon, 2 Aug 2010 09:51:34 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Sumproduct with 3 criteria +
To: exce
I have a workbook that needs a sumproduct.
I have:
=SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000))
What I need is a total of the result of that plus th
