Help needed for Sumproduct and Eomonth

[shmemushi]

Hi
Can you please check the attached pictures and help me with questions on colored cells
Thank you

excel.jpg

[kersplash]

Can you attach a workbook rather than an image?

Go Advanced -> Manage Attachments -> Upload

[shmemushi]

Excel1.xlsx

already attached in excel
thank you

[FlameRetired]

shmemusi,

This looks a lot like the problem you posed a couple of days ago here:

[shmemushi]

Yes and I thought your answer was the perfect solution, after i worked on it then other problems came out again so I had to post it again.
Thank you though for coming back again

[FlameRetired]

OK.

Since you need 0 returned on blank cells try this modified version of same. In C5 filled across and down.

Please Login or Register  to view this content.

Then for the summary enter this in B23 and fill down.

Please Login or Register  to view this content.

BTW: MONTH(A23&0) will coerce a month name into the month number.

[FlameRetired]

An additional thought.

Is there any chance Check in and Check out could span across 3 months ... for example Check in 31-Jul and Check out 2-Sep?

That would require an added step.

[shmemushi]

Thank you FlameRetired

No they wont work, can you try it on attached doc, already attached on the third reply, excel1

[shmemushi]

An additional thought.

Is there any chance Check in and Check out could span across 3 months ... for example Check in 31-Jul and Check out 2-Sep?

That would require an added step.

Very rare, for two months is ok for me

[FlameRetired]

Here it is.

I see what I missed.

Here is the modified formula and upload.

Please Login or Register  to view this content.

And by the way that layout should solve the question I asked earlier.

[shmemushi]

Thanks a lot FlameRetired

The layout you attached seems to be what i am looking for.

Thank a lot again

[FlameRetired]

You're welcome.

Thanks for the feedback and marking your thread Solved.