Hi,
I am trying VLOOKUP with Multiple Criteria in Google Sheets Using ArrayFormula, since there are more than one value on the table.
I need to SUM UP all the numbers that matches the criteria.
Could you tell me where I can add "SUM" into the below formula? Truly appreciated it
=ArrayFormula(iferror(VLOOKUP($H$2&H3,{$B$3:$B&$D$3:$D,$E$3:$F},3,0),0))
Last edited by juno612; 07-11-2020 at 08:02 PM.
why not just use sumifs (IF it is available in Sheets)?
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
Sorry, I am new on Excel. I just followed an instruction on one of the website but unfortunately didn't provide solution for sum up those have same values.
But you aren’t using Excel.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you, I added an helper column with concatenate then use Sumif, it worksOriginally Posted by FDibbins
I am using Google Sheet, it's works pretty much the same unless you think Google Sheet is Excel's rival gang. I better leave before I get beat up here....
No, not at all! But there are differences, so you need to be clear which you are using.
I moved this thread to the correct section and adjusted the title.
Thank you, I just joking...haha. You are right, I should make it clear, will do next time
Last edited by AliGW; 07-12-2020 at 02:28 AM. Reason: Please don't quote unnecessarily!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Juno, you may have the option to use sumifS(), the difference being sumif() only takes 1 criteria, while sumifS() can take multiple
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks