Sum Cells Based on Current Qtr (Part 2)

Hello All,

OK, I got a lot of great help earlier on what was a simple question apparently. Hopefully this one is too.

The attached worksheet shows rows of numbers that I need to add up by month. However, I have a delinquent qty that I need to add in only during the current Qtr.

For instance, during Q1 I want the Deliquent to be added in only for Q1 but not for Q2 through Q4, but I want Q2 to still add Apr, May and June data.

I hope that this makes sense. The attached spreadsheet should help clarify some.

Thanks

Kelly

Hello Kelly

From your description and example sheet im not fully sure I know what you need but I have put a couple of formulas below that may help.........

If you only want to add the delinquent for Q1 then this formula should work..

Please Login or Register  to view this content.

Otherwise if you only want to add the delinquent if the value in Cell C2 is equal to the current quarter then this should work....

Please Login or Register  to view this content.

Hope this helps

Cheers

Jim