Conditional VLOOKUP on Muliple Rows (or similar)

Hey all!

I am trying to make a query type application in Excel. Access would be better or an integration of the two but for now it needs to be Excel.

I need to loop through all the rows in a worksheet with this condition:

If COLUMN A = "X" then IF COLUMN B = "Y" then ADD what's in COLUMN C

Example:

Please Login or Register  to view this content.

I though VLOOKUP but then realized that won't work because it's only the first value it finds. I tried INDEX but couldn't get it to work.

I just need some guidelines. Not look for the code.

Thanks!

Originally Posted by 6StringJazzer

You need to use SUMIFS

Formula:

Please Login or Register  to view this content.

Yes! I knew it was a simple solution. This works like a charm and actually so much better since initially I was looping through each row and writting conditions.

This way I just denote the size of the sheet and plug in the conditions I am looking for.

Thank you!

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!