Hi all
I am struggling with what feels like it should be a simple solution, and it's frustrating!
I am collecting data by date and amount, and I want to add the values into the right column on a given table so that I can use it to calculate total amount in a particular month.
I have attached a simple example sheet to better explain what I mean.
The formula I am using is: =IF($B$2>=DATE(2012,1,1)<=DATE(2012,1,31),$C$2,0)
Any help will be greatly appreciated.
many thanks
Richard
Bookmarks