Sumifs for two date range not working

[SheetalGanesh]

Hi, I am creating a macro using worksheet function sumifs.

There are 3 col : brand name , purchase value & date.
I need to extract sum of purchase value based on brand name and start & end date.My procedure is as below:

Please Login or Register  to view this content.

Is there anything that im missing out as the function is not giving me the result.
Thanks in advance.

Sheetal

[puru.sve]

Hi Sheetal, Just minor change of datatype will help you to run this program.

Please Login or Register  to view this content.

[SheetalGanesh]

Hi
Thanks for the reply, but its not working.
The purchase value still comes as zero.

Thanks
Sheetal

[puru.sve]

Can you please confirm where are you placing the code and Is your raw data and output are in different sheets? or if possible atttach you file

[SheetalGanesh]

Hi,

Yes I am using 2 different sheets.
The data is in sheet2 & output in sheet1

Thanks
Sheetal

[puru.sve]

Then it should work ..... it is working on my side.... .

[SheetalGanesh]

Hi,
Im attaching my file maybe you could let me know where am i going wrong.

Thanks in advance
Sheetal

[puru.sve]

Hi Sheetal

Please try this code .. I just replaced the sumif because in your file the date has general format so it may have difficulties to read in date while running sumif function.

Please Login or Register  to view this content.

[SheetalGanesh]

Hi,

Thankyou !!! It works.

Regards,
Sheetal

[SheetalGanesh]

Hi,
Need one more clarification on how to take the count. Should i use worksheet function outside the loop?

Thanks
Sheetal

[puru.sve]

Just take a counter see below in code

Please Login or Register  to view this content.

[SheetalGanesh]

Thankyou so much for your time. its working.

Just one more question.Does "Sheet2.Range("K" & i)" means the counter goes to next row?

Regards,
Sheetal

[puru.sve]

No , it just adding value in range("E3").... and if condition goes true then counter will increase by one so counter will give you the number of times condition met.

[SheetalGanesh]

Thanks

Regards,
Sheetal