Hey guys
I hope your well, I am a little stuck on this formula and i am hoping you guys might be able to find a solution.
Aim - Column C row 25, I needs this to be a formula field. Basically i want to sum row 4, column C-N. But the calculation should only calculate based from beginning of the year to the month we are in.
So for example we are in September so i want the value in column C row 25 to say 121742.99.
Would appreciate any help available
Last edited by masond3; 09-03-2013 at 04:12 AM.
Try this..
Formula:
Please Login or Register to view this content.
Dragable..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi
As i see your data this formula should works for you.
=SUMPRODUCT(($C$1:$N$1<=MONTH(TODAY()))*(C4:N4))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
It's nice to see that you markrd your thread as solved. This means that one(or both) of our suggestions worked for you. In this point i'd like to mention that:
The feedback is always a sign of appreciation to the people who helped to find the solution to your problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks