Hi,

I have a data set that looks like this:

C3 to C17 has invoice type (Credit or Invoice)
D3 to D17 has period (Jul-14, Aug-14, Sep-14 etc)
E3 to E17 has invoice amount

I'm trying to get a year to date sum of all invoices until November 2014. So I need a sumif formula to only pick up invoices, and I want to sum until the period changes to Dec-14 (but not include any items from Dec-14 and onwards).

Anyone able to help me out with a formula? I think it would need to be index match but at the moment index match picks up the first occurrence of Dec-14, which I want to exclude.

Thanks in advance