Forum Discussion

Abhay1712's avatar
Abhay1712
Copper Contributor
Mar 22, 2020

SUMIF function shows zero as result

I am using SUMIF to add values in a column E  against text as "Client Total" in column C.  It always returns value as zero even though everything appears to be correct.

excel

2 Replies

  • Charla74's avatar
    Charla74
    Iron Contributor
    Mar 22, 2020

    Abhay1712 

     

    Change your formula from "Client Total" to "*Client Total*"

     

    Seems you may have spacing in front / behind those entries which would not match the search.

Resources