LinkBack URL
About LinkBacks
=SUMIF(RPC!$A$1:$A$1927,A1,epay!$F$1:$F$1194)
This is exactly the formula I tried. It returns 0, but it should be returning $129.30.
It resides on the RPC tab. Any idea what I'm doing wrong?
=SUMIF(RPC!$A$1:$A$1927,A1,epay!$F$1:$F$1194)
This is exactly the formula I tried. It returns 0, but it should be returning $129.30.
It resides on the RPC tab. Any idea what I'm doing wrong?
Using your formula:
=SUMIF(RPC!$A$1:$A$1927,A1,epay!$F$1:$F$1194)
One issue might be that you are referencing 1927 rows in the lookup column and only 1194 in the conditional column.
I believe that Excel will implicitly include the same number of rows as the lookup column, but just to be sure:
Example:
=SUMIF(RPC!$A$1:$A$1927,A1,epay!$F$1)
If that isn't the issue, then make sure the values in the conditional column are numbers and not text.
Does that fix the problem?
Ron
Last edited by Ron Coderre; 04-28-2005 at 08:26 PM.
Thank you very much for all your help! I modified your formula to work, here it is:
=IF(VLOOKUP(A2,epay,1)=A2,SUMIF(epay!A:A,A2,epay!F:F),0)
Thanks again!
Rob
I'm glad you figured it out.
One question, two comments:
1)By skipping the 4th argument of the VLookup, it defaults to an approximate match....Is that OK?
IF NO, then you need:
=IF(VLOOKUP(A2,epay,1,0)=A2,SUMIF(epay!A:A,A2,epay!F :F),0)
2)Do you have a Sheet AND a Range each named epay? I usually try to avoid that situation.
3)I'm pretty sure you could cull your formula down to:
=SUMIF(epay!A:A,A2,epay!F:F)
Regards,
Ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks