Sumifs function

[madocar]

Hi there,

please can you help me out with sumifs function?
I attach an excel file.
I want to sum row 2 according to how many values I have in row 5. I will be filling row 5 in the future so I want to automate it when I put another date in row 5 It calculates row 2 again.

Thanks

 

[Somendra Misra]

Hi madocar,

Is row 6 data your desired output if no, than what you expect the output?

Regards,

 

[madocar]

Hi Somendra Misra,

no, I expect to have my output in one cell.
The output is the sum of A2:M2 in this case. But if i put another value to N5 then the output is the sum of A2:N2.

regards

 

[Somendra Misra]

On row 5 you have date of Aug month but data is of July month. can you explain this

Regards,

 

[madocar]

Yes that is right. I'm going to fill row 5 ... day by day. Today is 13th of august. And I want to compare sum of the same period of time. First of august till 13th of august comparing to 1st of July to 13th of July. Sum rows are 2 and 6

Thanks

 

[Somendra Misra]

And after this will you also start a range for September month also?

Regards,

 

[madocar]

August is enough

Thanks

 

[Somendra Misra]

See the file.

Regards,

 

[madocar]

Speechless .... absolutely amazing. That's exactly what I wanted!
Thank you so much Somendra Misra

 

[Somendra Misra]

You are Welcome!!!

Regards,