View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rif Rif is offline
external usenet poster
 
Posts: 15
Default SUMIF / COUNTIF Problem

I have a list of extensions I want to count or sum their respective sizes.
However, the SUMIF formula treats: .0 .00 .000 as 0. I need each
one to be counted or summed. I have tried to force the issue with TEXT() to
no avail.

Any assistance would be appreciated!