In this function: =SUMIFS(N$13:N$100001;U$13:U$100001;"under";T$13:T$100001;">90";W$13:W$100001;T5). Why can't I replace 90, which is criteria2, with a cellreference containing the number 90, or any other number?
When I replace 90 with S7 the function does not retur the same output, even thoug S7 equals 90.
The sumifs functions are in the area U3:U9 in the attached file. Thanks so very much for any help!
Moderator note:
I have taken the liberty to change your thread title.
Bookmarks