LinkBack URL
About LinkBacks
I'm trying to use this formula but I keep getting an #value error
=SUMPRODUCT(--('[Weekly Sheets.xlsx]W1'!$B$5:$B$199=C1),--'[Weekly Sheets.xlsx]W1'!$D$15:$D$199="W*1")
If worksheet W1 in cell D15 has a "W" looking for a result of 1
Thanks
I'm trying to use this formula but I keep getting an #value error
=SUMPRODUCT(--('[Weekly Sheets.xlsx]W1'!$B$5:$B$199=C1),--'[Weekly Sheets.xlsx]W1'!$D$15:$D$199="W*1")
If worksheet W1 in cell D15 has a "W" looking for a result of 1
Thanks
Last edited by Killer17; 10-16-2008 at 12:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks