Hi all,
tried to make a simple file for my job to count stuff automatically.
this does seem to work just fine with a COUNTIF formula. the problem here is that the range from the formula changes every new day by itself..
the formula has to look for its data to another worksheet inside the workbook which is linked there with an external workbook.
it's set up in a way that i only have to "re-save" all required files on their destination and then refresh the homefile(where the problem occurs).
the refresh updates the links with the external files and gives me a count on how many trailers that have been ordered. example of the countif formula below
ex: =COUNTIFS('order trailer Today'!H21:H100, "W*")
above formula does work! but when i refresh all my files (next day) the range in the formula changes by itself..
ex: =COUNTIFS('order trailer Today'!I21:I100, "W*")
does anybody know a solution for this? thank you in advance!
kind regards
Miguel
Bookmarks