Microsoft Excel 2007 Tutorial - New SUMIFS Function in Excel 2007

[asenacat]

Thank you thank you thank you!!! i had a deadline to meet today!!! and because of this im going to meet that deadline!!! thank you again!!

[MrSaulgud]

This has been very helpful, but I am trying to do a combination of both SUMIFS and VLOOKUP functions. In my case I have Todd and NY on one sheet with his MULTIPLE sales and I would like to add a function on my forecast sheet to look up the total of all of Todd's sales in NY in one cell to compare against his lump some forecast. If you are aware of how to help in my issue it would be greatly appreciated.

[watercolor0111]

thank u so much

[papisudeep]

Suddenly My Friend ask about a conditional sum...I somehow solved his problem but ...not this easily ...Vry happy to see your tutorials....Thnx :-)

[SuperZeppelin1973]

SUMIF is great, but isn't this already handled by Pivot Tables?

[599CD]

@SuperZeppelin1973 Sure, you can get similar results with a Pivot Table. This is just one more tool for your Excel arsenal. If you don't want to go through setting up a PT, you can use this handy function.

[sameshar]

Thank you. A good tutorial.

[saadbinarshad]

Thanx alot ! It helped alot !

[rob4wvu]

That helped a lot!

[generous2100]

pretty much helpful mate thanks

[MoFroBo]

Thank you man :)

[king04567]

what if we want to sum 65 nd 56 cell?

[SAEED77774]

Thanks so much. I am really looking for that and i found your video so easy for me and i am so happy.

Thanks Thanks to you.

[ythiagarajah]

Great tutorial. Figured it out in minutes.

[samoooooo52]

u r really expert :)

[htailor77]

What if would like to make total with condition below:

Rep=Joe,Todd & Jim

Office=NY

[Blood69Tiger]

Thanks man, you just helped me make my homework! ;D

[shahabbangash]

Too much easy with big experience..Thumbs Up!

[InChainsiStillRemain]

Thank you for this tutorial. Helped me alot! :)

[amicableq]

Thanks man, good tutorial.