Solved sumif based on a criteria

April 10, 2013 at 19:29:23
Specs: Windows 7
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.


See More: sumif based on a criteria

Report •

✔ Best Answer

April 10, 2013 at 19:43:34
Excel 2007 and later have a SUMIFS function.

You can SUM a range based on multiple criteria.

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

Report •

April 10, 2013 at 19:45:43
I am very, very thankful for your quick response! Have a great night!

Report •

April 10, 2013 at 19:48:26
It turns out I'm working with 2003. Is there anything else I can do?

Report •

Related Solutions

Report •

Ask Question