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$2 and if it = $R$1"
I assume that if the result of the SumProduct formula = R2 AND = R3, then you
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: excel-macros@googlegroups.com
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 the same if it = $R$2 and if
it = $R$1.
Any ides for Excel 2003? Thanks
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
