On one worksheet I have a set of Dates in Column H, Amounts in Column I, and Project #'s in Column L. I want to get the sum of the project # (in column I, GL Tab) for the first quarter of the year only (based on Column H, GL tab) on the CP tab. As time goes on I will want Quarter 2,3, & 4 in separate columns on the CP tab... I have tried several formulas, but they just aren't working out. I have done sumifs, sumif, and if formulas.
Does anyone have a suggestion? Seems like this should be easy but my spreadsheet just isn't working out. I'm going cross-eyed at this point.
Here's the last formula I tried, but it just give's me $0.00's... I thinking my date criteria is messing things up.
=SUMIFS(GL!$I:$I,GL!$L:$L,CAPEX!$A6,GL!$H:$H,"<=3/31/11")
I have attached a small spreadsheet with examples. I want my formulas on the "CP" Tab, my orig data is on the GL tab.
Any help would be appreciated.
Bookmarks