Any thoughts on how I can convert this
=(SUMIF([FML_LIVE.xls]Database!$10:$10,">"&$B23,[FML_LIVE.xls]Database!$27:$27)-SUMIF([FML_LIVE.xls]Database!$10:$10,">"&$B24,[FML_LIVE.xls]Database!$27:$27))/4
into SUMPRODUCT.
Where B23 and B24 are dates i.e 1 july 2010 and 30 june 2011
Thanks in advance
The B23 and B24 is in Date format?
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
It is, 1-jul-2010 etc...
If no working, please give full path to the formula, C:/MyDocument/[FML_LIVE.xls]
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks