Dear sir,with best regards,how can i adjust this formula to avoid (#VALUE!) appearance for empty cells.
Many thanks in advance.
(=SUM((AK6:AK15000>=AM4)*(AK6:AK15000<=TODAY())*(AH6:AH15000)*(AJ6:AJ15000=AM6))
Dear sir,with best regards,how can i adjust this formula to avoid (#VALUE!) appearance for empty cells.
Many thanks in advance.
(=SUM((AK6:AK15000>=AM4)*(AK6:AK15000<=TODAY())*(AH6:AH15000)*(AJ6:AJ15000=AM6))
Last edited by tofimoon4; 06-05-2012 at 09:35 AM.
If you're using a Excel 2007 or above you can:
=IFERROR("your formula here",0)
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Try since I am not sure which version of Excel you're using, so I will go with 2003's formula.
=IF(ISERROR(SUM((AK6:AK15000>=AM4)*(AK6:AK15000<=TODAY())*(AH6:AH15000)*(AJ6:AJ15000=AM6))),"",SUM((AK6:AK15000>=AM4)*(AK6:AK15000<=TODAY())*(AH6:AH15000)*(AJ6:AJ15000=AM6)))
Hi
If you are in Excel 2007, did you try IFERROR?
In oldest versions, IF(ISERROR)---
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.
My dears many thanks for help
You are welcome
Would you pls, mark your Thread, as Solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks