Combine Vlookup and Sumif function
hello
i m using this vlookup formula to look the value..and
Please Login or Register to view this content.
i m using this sumif formula to sum of value...Please Login or Register to view this content.
i want to combine them, first lookup the Criteria then sumif the criteria
but i want sum ofwith criteria D10Please Login or Register to view this content.
thanx
Hi,
Please upload a sample template of your workbook here.
HELLO
here is sample workbook
=sumif('ol bc'!e:e,entry!d10,'ol bc'!e:f)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
Please use the following formula, it works. I have updated the same in the workbook attached here.
=SUMIF('OL BC'!E9:F20,ENTRY!D10,'OL BC'!F9:F20)
Regards,
Chandra
Please click on ‘* Add Reputation’ button on the left side bottom of my post if you liked my answer.
Thanx a lot cbatrody
works fine
will add u repu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks