In your forumla, $B$3:$B$1346 should be $B$3:$B$1048576 too
else
=SUMIFS($K$3:$K$1346,$N$3:$N$1346,N3,$B$3:$B$1346,"=No") if your range of data is between rows 3-1346
In your forumla, $B$3:$B$1346 should be $B$3:$B$1048576 too
else
=SUMIFS($K$3:$K$1346,$N$3:$N$1346,N3,$B$3:$B$1346,"=No") if your range of data is between rows 3-1346
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks