Created attachment 131835 [details] Picture from function help tool Hello Support No empty cell what to sum but there is 0 in cell value area and gives error message 510. in my meaning i want to count sum from specific huge area what includes datasheet values 0-1, from given cell sum areavalue 0-25 area text is in finnish but i link picture from it Comparing area is from 1 to 150 So sum count area is only from less and equal from value i search Yours, Mika Nikkari
Please attach test file. Thank you
You can't put directly the comparison operator how you are doing, but: ;F38:F187;"<="&A189) putting it between quotes and concatenated with the search expression.