For some reason when I do SUMIFS it is returning a NIL balance when I am confident the data is right.
For example, Column D has 5 variables in it: Red, White, Blue, Black, Gray which repeat themselves a number of times. Column E has values in it.
D E
Red 5
Black 6
White 3
Red 2
Blue 3
Black 4
White 3
Gray 2
Blue 1
Red 9
Gray 12
Blue 3
Black 2
White 3
White 4
Gray 10
If i Do a SUMIFS(E:E, D:D, "red", D:D, "blue", D:D, "white")
this will return NIL. But if I do a SUMIFS on say red only it pulls the number. Any input please?
Thanks!
Bookmarks