Extract value or sum total based on month criteria that falls within Data Range

Hello Friends,

Trying to sum a column containing project resources by month and year.
Attached is sample data along with requirement. Any help is much appreciated.

Thanks

Hello Mysore,

Try this in I8:

Formula:

Please Login or Register  to view this content.

Copy-paste across and it should (hopefully) do what you want.

Cheers

Hi All,

another possible solution, again in I8

Please Login or Register  to view this content.

Regards

Canapone,

very elegantly done sir. Where is the salute button on this? :-)

Cheers

PS: not to nitpick but the semicolon after H8 should be a comma... <sheepish grin>.

Ciao,

and thanks: ";" was an unfortunate leftover from Italian settings.

Please Login or Register  to view this content.

I suspect that your formula is more reliable than using MEDIAN.

I did not have the courage to test it on wider periods .

Regards

Mysore,

it won't work with EOMONTH as it doesn't take an array. And I don;t think MEDIAN does either. (I mean it does but not the way we want it to in this formula i.e. to calculate each row array separately. it calculates the median for all the values in the array.)

Try this in I14:

Formula:

Please Login or Register  to view this content.

Cheers