If text then Sumif

[staniel777]

Hi

In my excel spread sheet (attached below) I am pretty much trying to do put an equation in G7.

If B:B=Pokemon then sumif(C:C,G6,D:D)

just not sure how to format it so excel can read the formula.

Thank you

[sktneer]

Hi staniel,
Welcome to the Forum.

Try this...
In G3

Please Login or Register  to view this content.

and then copy across to I3.

In G7

Please Login or Register  to view this content.

and then copy across to I7.

Is this what you are trying to achieve?

[NumbersGeek]

Does - =SUMIF(B2:B17,G5,D2:D17) get you what you need?

[staniel777]

Thank you Sktneer. It worked

[sktneer]

Glad I could help.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks to them.