how to get the sum of data on a specific date range

[laurenwyne]

hello good day to all,

my question is how to sum the data on a specific date range

i'll put the date from and the date to to get the total sum.
Tried using sumif however it counts all the data that i have selected, i am not knowledgeable on how to put a statement wherein it will be on a specific date.

Thank you in advance

Date From:5/1/2010
Date To: 5/31/2010
Total Sum:2072.72

[laurenwyne]

heres teh attachment

[Potholes]

Please edit your post and place an attachemnt of a dummy sheet up so that we can look into it for you.

Potholes

[laurenwyne]

have attached the file. thank you

[Haseeb Avarakkan]

Try,

=SUMIF(E:E,">="&H2,A:A)-SUMIF(E:E,">"&H3,A:A)

[laurenwyne]

Hi Moderators

The issue has been resolved, I am not able to find the prefix dropdown.

Thanks
laurenwyne