Sumif and Left Functions?

[2709236]

Can I embed a left formula into a sumif function?

I want to build a check into my spreadsheet without building on new columns. A quick example is attached.

I want to sum dollars by groups O, D and E, and by month by referencing the groups tab.

Thanks for the help!

[Ron Coderre]

Using your posted workbook...try this:

On the Dollars sheet...

Please Login or Register  to view this content.

Copy that formula across and down through G20

Does that help?

[2709236]

Worked like a charm.

Thank you!