Let me try this again. Sheet 1 has info in B, C and D that needs to match info Sheet 2 column F, G, and H. If those all match then I need to check if column AH in Sheet 1 matches either R2, R1 or R4 in Sheet 2. If so, then I need to sum column X in Sheet 1. The result needs to show on Sheet 2 in colum R and all the rows beneath where there is data. did that make more sense? I'll create a little sample and attach it since I don't have the original on this computer.
Thanks so much.
________________________________
From: Dave Bonallack <davebonall...@hotmail.com>
To: "excel-macros@googlegroups.com" <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.
"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
--
----------------------------------------------------------------------------------
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
sample for sumif+.xls
Description: MS-Excel spreadsheet
