Forum Statistics
- Forum Members:
- Total Threads:
- Total Posts: 8
There are 1 users currently browsing forums.
|
 |
02-09-2010, 05:18 PM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: Toronto, Ontario
MS Office Version:Excel 2003
Posts: 39
|
|
|
Sumproduct combination
Please Register to Remove these Ads
I know this will come off as such a newbie question and i apologize but i'm just getting the hang of this whole excel thing lol...
How can i get this formula to work?
Code:
SUMPRODUCT(--ISNUMBER(SEARCH("Yes",$A3:$H3)),SUMIF(Sheet4!$A$1:$A$8,$A$1:$H$1,Sheet4!$B$1:$B$8)+(--ISNUMBER(SEARCH("Yes",$I2:$J2)),SUMIF(Sheet4!$A$1:$A$8,$AA$1:$AB$1,Sheet4!$B$1:$B$8)*J2)+SUM($I:$J3)
I am trying to calculate the total of A-H and add it to the total of I*J.
Please see attachment.
Thank you,
Zanna
Last edited by NBVC; 02-09-2010 at 05:48 PM.
|
02-09-2010, 05:18 PM
|
 |
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,378
|
|
|
Re: Newbie Question - What's wrong with the formula?
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
02-09-2010, 05:25 PM
|
|
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,378
|
|
|
Re: What's wrong with the formula?
You should try to describe what it is the formula is supposed to do for you... and then create a brief description of that problem for the title.
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
02-09-2010, 05:37 PM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: Toronto, Ontario
MS Office Version:Excel 2003
Posts: 39
|
|
|
Re: What's wrong with the formula?
Please see post for revisions.
Thanks,
Suzanna
|
02-09-2010, 05:43 PM
|
|
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,378
|
|
|
Re: Sumproduct Formula Trouble
for the J column, will you be entering quantitites only if greater than 1?
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
02-09-2010, 05:44 PM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: Toronto, Ontario
MS Office Version:Excel 2003
Posts: 39
|
|
|
Re: Sumproduct Formula Trouble
Yes, we plan on entering a figure only if we intend on taking them more than once.
|
02-09-2010, 05:48 PM
|
|
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,378
|
|
|
Re: Sumproduct Formula Trouble
Perhaps then:
Code:
=SUMPRODUCT(--ISNUMBER(SEARCH("Yes",$A2:$H2)),SUMIF('Event - Value'!$A$1:$A$8,$A$1:$H$1,'Event - Value'!$B$1:$B$8))+SUM($A2:$H2)+IF(ISNUMBER(SEARCH("yes",$I2)),SUMIF('Event - Value'!$A$1:$A$8,$I$1,'Event - Value'!$B$1:$B$8)*IF($J2>0,$J2,1))
copied down
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
02-09-2010, 06:00 PM
|
|
Registered User
|
|
Join Date: 05 Feb 2010
Location: Toronto, Ontario
MS Office Version:Excel 2003
Posts: 39
|
|
|
Re: Sumproduct
That's terrific, thank you so much!
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
