Having trouble with this one. These are the rules I want to include in that formula above:
Please Login or Register to view this content.
* If there is a date in column: ((TEXT('Overview - 2013'!$D$15:$D$5000,"mmmm")=B3) then use THIS date range that is eqal to "B3" in the formula above. If there is NOT a date in there, then use: ((TEXT('Overview - 2013'!$M$15:$M$5000,"mmmm")=B3)
So basically, column D takes precedence over Column M... Not sure how to include that rule?
Hi ,
upload a sample sheet
Punnam
I will upload if this is till vague... but something like this:
What do you think? It's returning an error though?HTML Code:
Here is an example spreadsheetOriginally Posted by Punnam
You are only uploading part of your ongoing problem. Without the rest, it is nearly impossible to give you an answer. The formula that you give is part of a solution given earlier addressing cells that are not present in the current post.
You want Column M to take precedence over column D if column D doesn't have a date matching B3.....What is the aim of this as there might be a better way of accomplishing the goal?
What is the final goal for this worksheet?
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Whoops! I left a column out!!
Column I will have £25 or £50 in it (Mixture - just put a random combination all the way down on the rows that contain data...)
Here is what currently works at the moment: =SUMPRODUCT((TEXT('Overview - 2013'!$M$15:$M$5000,"mmmm")=B3)*('Overview - 2013'!$I$15:$I$5000>0),('Overview - 2013'!$I$15:$I$5000))
This formula is placed into B8 on "Monthly Bonus 2013"
Hope this helps?
Here you go, this should give more transparency!
Sorry for being vague
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks