Hi,
i cannot get thru with the minus or equal to today as the system rejects always the middle formula: <=today()
can you assist,
best regards,
fausto cruz
Hi,
i cannot get thru with the minus or equal to today as the system rejects always the middle formula: <=today()
can you assist,
best regards,
fausto cruz
Fausto Cruz
=SUMIFS(C10:C200,TODAY()'+'15,0)![]()
Do you want to sum the numbers in range c10:c200, if the dates that exists in other column(which one??) are <=Today?
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.
Statement 1.xlsx
I have attached the file that contains the sheet were I was working at...
Tryand![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Hi Guys, Many thanks, this worked very well.
Thank you
Kind regards,
Fausto![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks