SUMIF Help

Originally Posted by oeldere

If you are able to change the format of the data, you can use pivot table.

See the example.

And for the change of format see the link below.

http://www.excelforum.com/excel-prog...ose-macro.html

Thanks, but because I have multiple tabs (over 20) that I'll be pulling data from, and then combining it all into one output tab, I don't think the pivot table will work in this instance