Find last cell value in a column when other column's data is in range...

[kopapa]

Ok, here's my problem:

Sheet A:
In A4:A I've got dates (actually in an ascending order)
In H4:H I've got numbers (that are not supposed to sum, only LAST number is always significant)
In all other columns I've got numbers to sum up.

Sheet B: (Sums up data in months)
In A4:A I've got MONTHS (June 2016 etc)
In ALL other columns I've got formula's (SUMIFS) to sum up numbers from Sheet A IF dates in SheetA: A4:A range falls within specific month.
In H4:H the dates criteria MUST still be valid (i need data for specific month) BUT I don't want to sum up, just find the last value (which may be of -let's say- June 30th BUT it can be of June 29th if there are no data in June 30th)

SUMIFS formula I use (with no problems):
=SUMIFS('2100'!H4:H1000;'2100'!$A$4:$A$1000;">=1/06/16";'2100'!$A$4:$A$1000;"<=30/06/16")

where (2100, 2200, 2300, 2400, 2500 are source sheets of course...

I simply cannot think of an appropriate formula for H4:H!!!

Can you help?

Thanx!!!

 

[Jeffrey Lopez]

Saw this on another site , was there a reason it was removed? did you already get an answer for it?

 

[kopapa]

Saw this on another site , was there a reason it was removed? did you already get an answer for it?

Did you? Well, I didn't post it! My first post here, but if I don't get some help then I will probably post it in another site as well

Have a nice day!