Wondering if anyone can help me please?
I am trying to get a formula to work and cannot figure out why it wont!
I am looking to add together costs if the date in which the costs occurred fall within or are equal to specific dates.
The formula I have detailed below is working for if the date of cost occurring is between the dates but I would also like it to pull through if it occurs on the same date
=SUMIFS(Table2[Total Cost of Fogging],Table2[Date of Fogging],">"&Summary!B18,Table2[Date of Fogging],"<"&Summary!C18)
I thought that by adding "=" before the ">" and after "<" this would solve the issue but it doesn't seem to work
Sorry if this has been posted before, I'm new to this forum and would greatly appreciate the help!
Bookmarks