Hello
I have a pool of data that needs to be placed in buckets
i.e.
1 (should not include National)
2-19 (should not include National)
20+ (should not include National)
National
i used the sum product in my range but it's not working and giving me the incorrect results ( im pretty sure).
this is my formula in cell F8
=SUMPRODUCT(--('Max Consoles'!$U$2:$U$54272>=2),--('Max Consoles'!$U$2:$U$54272<=19),'Max Consoles'!$U$2:$U$54272)
basically....this is being applied for the bucket 2-19
-im trying to figure out from my data, the consoles that are in 2-19 range, that are also not coded national. im using column "U" in max consoles worksheet to show non national codes.
if someone can kindly and pls help me that would be great thx u.
Bookmarks