Hi,
I was wondering if there were limits to the Application.Evaluate?
I'm trying to runwhere the formula is: FileLookupColumnG stored as a named formula
Evaluate(target.formula)
and
FileLookupColumnG = =SUMPRODUCT(IF(ISNUMBER(Output!$G$4:$G$846)(Output!$A$4:$A$846=INDEX(INDIRECT(ADDRESS(ROW(),1,)),1))*Output!$G$4:$G$846,0))
Not sure why the formula doesn't evaluate?
Does the formula working in Excel?
Can you send a short sample of your Excel file.
- Battle without fear gives no glory - Just try
I cannot send a file unfortunately without recreating data and so on and son. But yes the formula works in Excel.
The formula syntax is invalid. Try putting it in a cell.
Entia non sunt multiplicanda sine necessitate
I have some doubt how the formula is working, see the )( inside ...!
You're 107% correct, not sure where that other parenthesis is coming from. Trying again
=SUMPRODUCT(IF(ISNUMBER(Output!$D$4:$D$846),--(ClientOutput!$A$4:$A$846=INDEX(INDIRECT(ADDRESS(ROW(),1,)),1))*Output!$D$4:$D$846,0))
Shg wud up man. Next time I'm back home in the Great Country of TX I owe you coffee or something
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks