Hello there,
I am trying to have the following to work but I am not sure as I am getting 35 all the time regardless what the value of the cell is.ie.David, Joe, Sam, Jack. Also Cell C3 = 35%
Thanks in advance.
Please Login or Register to view this content.
E-
"Producers"?????
try giving cell reference instead of producer. e.g. A1
"Producers" is a name range for ='Sheet'!$DY$4:$DY$9
Logical test in IF function tests value in a cell not in a range as you mentioned in your formula that is why is giving the answer for "value if false" all the time.
Any suggestions?
Can you share sample work-sheet and then let me know your desired result?
May be "AND" formula work for you. put AND test for logical test in IF function.
Try this to pull out the totals...
=SUMPRODUCT(($B$2:$B$9)*($A$2:$A$9={"aa","bb"}))
I used the following table...
aa bb dd cc ee aa bb dd
You can adjust/expand the {"aa","bb"} part as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Producers may be a named range. "Producers" is a string literal which would equal "Producers"Originally Posted by enetworks
it is unclear what you want.
try:
and see if the result is as desired. if not, try with AND instead of OR. if still not satisfied, attached a sample spreadsheet with expected results indicated.Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks