I'm trying to sum only the items in a list divisible by 100. I got as far as testing for divisibility by 100 using =MOD(List,100)=0. And I found how to count instances of divisibility by 100 with =SUMPRODUCT(--(MOD(List,100)=0)), but I can't quite figure out how to make the leap to summing. (I feel like SUMPRODUCT can probably do it, but I'm never quite sure what I'm doing using SUMPRODUCT.)
Any help would be greatly appreciated.
Bookmarks