Hi
For accounting I want to have a recheck in calculation.
But I can not explain why
SUMIFS(19ie.D2:D1000;19ie.$D2:$D1000;“1”) =161
does not equal exactly with
the sum of all results from a column with cells containg
=SUMPRODUCT(19ie.D$2:D$1000;NOT(ISERROR(FIND($B8;19ie.$B$2:$B$1000)));19ie.$D$2:$D$1000=1) … =158
Happy about any ideas.
Here is the corresponding file …