Hello,
I want to create a Numbers table that will gather the cell value based on 2 criteria. VLOOKUP lets me use only one criteria.
Is there another formula I should be using instead?
Thank you!
Alex
MacBook Pro (Retina, 15-inch, Mid 2015), macOS Sierra (10.12.5)
You can use SUMIFS, something like this:
The formula in this example, input into C2 and filled down, is this:
=SUMIFS(Table 2::C,Table 2::B,B2,Table 2::A,$A2)
SUMIFS allows you to apply more than one criteria. It works in column-condition pairs. See more about the function here. (You can switch to your language in Help > Formulas and Functions Help in your menu.)
SG
You can use SUMIFS, something like this:
The formula in this example, input into C2 and filled down, is this:
=SUMIFS(Table 2::C,Table 2::B,B2,Table 2::A,$A2)
SUMIFS allows you to apply more than one criteria. It works in column-condition pairs. See more about the function here. (You can switch to your language in Help > Formulas and Functions Help in your menu.)
SG
It looks like you want the total for the account "Savings" for the month of October.
you can use sumifs() which will sum only when all conditions are true
however, since all accounts shown are Savings it seem like a lot of work. Is this a true representation of what the data will look like? or is there a more complete set?
VLOOKUP() only returns based on a value from a range being exactly the same as or less than or equal to a test value.
also... it is often better to describe what you want to do, omitting the how. Present the problem , let us suggest the how.
Thanks SG!
It worked out perfectly.
Thanks Wayne!
Here's what I'm looking to achieve. I want to have the Savings sums for each month on a separate Table. I use the Table 2 as my account summary and the Table 1 will show my Savings trends.
Hi SG,
Your answer solved my question. I hit the solved button on my answer by mistake instead of yours... And there was no option to click solve on your post afterwards... If there's a way to so, please let me know.
Alex
Hi Alex,
I'm glad "it" worked for you, and that you were able to solve your own question. Did you find any of the posts here helpful in solving your question?
SG
Alex,
I think how it works is that you have one Solved, which you can't change, and also two Helpfuls. Posts marked with either are displayed at the top of the thread for future readers.
SG
VLOOKUP with Multiple Criterias
