Season to date sales - sum of specific cell within a daily date range

[Amr Hicham]

daily sales.xlsm

Hi All,

this is my first post,
and I would like the community's support
I've been trying to get this formula to work but no can do

What i need to do is to calculate Last Season Sales (Which is the sales of specific departments between start and end dates)
sales available in the first sheet Dept. sales

My formula is giving me the same result in all cells 3.8 million which is actually wrong and i do not get the reason why


Best regards,

Amr

[Beamernsw]

I'm not sure if this is close or not, but try this in cell D10 and copy down. (non array).

Please Login or Register  to view this content.