1.

Solve : Excel 2010 Function?

Answer»

Hi there,

I can't seems to be able to figure this ONE out so hopefully you can help me!

I want to make the sum of D only if C=COL. So then i WOULD get a total of 30$.
I also want to add something between BOBBY Four and Five ans call it Boddy Six with a value of COL and 5$, do the same IF and get 35$.

http://img405.imageshack.us/img405/2551/exceln.jpg

Help?dubek,
You need to read up on Excel Tutorials.
Google: Excel 2010 tutorial
Like This...Have a look at the REFERENCE page for the SUMIF() function. That should fit your bill.Quote from: Rob Pomeroy on August 16, 2011, 02:43:03 AM

Have a look at the reference page for the SUMIF() function. That should fit your bill.

The SUMIF function was the one i was looking for. It took a while to figure how to do it but i did. Thanks Rob!Good JOB.


Discussion

No Comment Found

Related InterviewSolutions