sumif command help

I want to be able to grab data from one cell if the conditions of another cell are met. For example:

cell a1 has GAME in it
cell a2 has 24 in it

I want to use a formula where if a1=GAME then copy a2

I thought perhaps the SUMIF function may do this with sumif=(a2,a1="GAME") but it returns a 0 result. I looked at the count if formula but it only counts but I want the result that is already in cell a2

Hope this explains what I am trying to do well enough...please let me know if I am using the right function, or what function I should be using to achieve this.

Thanks!

Hi and welcome to the board.
Supposing you want the result in cell A3, in this cell enter =IF(A1="GAME",A2,"")

Or do you want another outcome if the condition is not met?

Thanks for that...that pretty much does it...what would I need to add if I wanted it to return a 0 result rather than false? doesn't matter too much as this does give me what I want.

Thanks

Opps...didn't use the "" part of the formula which gives a blank response if condition isn't met! Good to know...thanks for the assistance

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save