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
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
Hi staniel,
Welcome to the Forum.
Try this...
In G3
and then copy across to I3.Please Login or Register to view this content.
In G7
and then copy across to I7.Please Login or Register to view this content.
Is this what you are trying to achieve?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Does - =SUMIF(B2:B17,G5,D2:D17) get you what you need?
Thank you Sktneer. It worked
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks