This is my first post and being a novice on Excel i would appreciate any help i can get. I have
Excel 2002(I know it's old but it works - just like me!!) and have a particular problem as follows:-
I have tried
various sumif and sumproduct and even combination of both, but cannot get this to work.
I have the equation below
to produce any costs that fall between January 1st 2007 and 31st January 2007 (with the cost column being N) which works
have this one which looks for anything that begins with an 'F' in the H column and works out the value (N column again). This
also works fine.
What I want to do though is produce values
that begin with an 'F' but fall within the date range 1st Jan 2007 - 31st Jan 2007.
It's probably dead easy but my
brain hurts now.
Any help would be very much appreciated.