i have labeled a series of data by month in column A, followed by a description and an amount in columns B and C. i want to add up column C based on the description in column B, but only if column is Jan (for example). i know i need an if and a sumif function, but i can't seem to figure out the proper formula.

thanks!

✔ Best Answer

Excel 2007 and later have a SUMIFS function. You can SUM a range based on multiple criteria.

http://office.microsoft.com/en-us/e...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

I am very, very thankful for your quick response! Have a great night!

It turns out I'm working with 2003. Is there anything else I can do?

Ask Your Question

Weekly Poll