Search code examples
excelformatsumcellformula

Excel SUM\SUMIF based on cell number formatting

I have a row containing cells with different formatting

they look the following

  • 85
  • 32%
  • 45
  • 23%
  • 11
  • 5%

the result i need to achieve is to SUM only the number formatted cells (not the percentage ones) without any additional rows. No clue how to do it.

Thanks so much.

Solution

  • Asuumuing your data is in A1:A6

    =SUMIF(A1:A6,">"&1)