Hi
I seem to be struggling with using less than or equal to within a formula. I have attached a basic sheet showing what i am after.
I use data from an SQL database to record monthly cost and wish to use excel to determine what the cost was to the end of one period and the end of the previous period.
It seems that i cannot get it to work! Please help....
Cheers
Book3.xlsx
For Current period
=SUMPRODUCT(--($A$7:$A$157<EOMONTH(A1,-1)),$B$7:$B$157)
For previous period
=SUMPRODUCT(--($A$7:$A$157<EOMONTH(A1,-2)),$B$7:$B$157)
Life's a spreadsheet, Excel!
Say thanks, Click *
Your sheet isn't working because you're converting the dates in cells A2 and A3 to text with the TEXT function. Just use the EOMONTH function on it's own.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Book3.xlsx
Ciao,Innerise forse basta modificare formula A2 ed A3 .
Vedi file
Hi
Thanks.. That is perfect for doing the total split between periods. I missed out including the element that i need to break the cost down by, i have now included that in the attached.
I will need to return the cost per line, if thats possible?
Cheers
Book3.xlsx
Current period
=SUMPRODUCT(--($A$7:$A$157<EOMONTH($A$1,-1)),--($C$7:$C$157="Labour"),$B$7:$B$157)
Adpat accordingly for previous period and other elements
Thanks to all of you... its all sorted (i feel a little sheepish as i should have guessed it was a formatting error)... the sum product formula will also help a lot..
Brilliant, thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks