I've been using =SUMIF(C$5:C$317,"0.5") - column C can contain any value
between 1 and 50 or text and I need the sum of any numerical values, but I
only need it to use this if cells in column B meet a particular criteria.