LinkBack URL
About LinkBacks
What this currently does is if P:P match whats in R2 then it sums whats in M:M
What I need is iif... P:P matches whats in R2 and if K:K matches whats in W2 then sum what is in M:M
What this currently does is if P:P match whats in R2 then it sums whats in M:M
What I need is iif... P:P matches whats in R2 and if K:K matches whats in W2 then sum what is in M:M
The version of excel you have listed (excel 2003) is correct?
Please click the * icon below if I have helped.
Since you're using Excel 2003, you could try SUMPRODUCT:
You'll need to limit the ranges (don't use whole columns).
Please Login or Register to view this content.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
I interpret you problem as having values in column P that are different than the values in column K but both sets of values are attached to the values in column M and that you want the sum of the values that match R2 and W2. You should limit the length of the ranges instead of having whole columns.
Formula:
Please Login or Register to view this content.
<---------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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks