If as you say column D on Posting contains blanks then your DNR will not be created properly... COUNT will obviously ignore blanks (it counts Numerics...)
Note: for purposes of demo I'm assuming your technician values are numeric ids formatted to say 0000 rather than being actual text
(ie ISNUMBER(technician value) = TRUE)
Consider
Then the following DNR's
will generate a range A1:A5
will generate a range B1:B4
The COUNT in the 2nd range (B:B) = 4 thus the range is only 4 rows high...
In Sumproduct terms having ranges of different dimensions will invariably cause problems.
If Technician never contains blanks then setup InDate off that range:
You should then find your DNR will work:
using sample data the above would return 1
Bookmarks