SUMIFS

[LINDA1259]

IN THE FORMULA BOX I CAN SEE THE TOTAL AND ITS CORRECT BUT WHEN I HIT ENTER I GET A 0 OR BLANK CELL?  

[#2]

Hi , it would be better if you attach the file. Possibly, there could be something with the "cell Number Format" . If you share file here, people can understand the situation better. (You may want to delete the other irrelevant stuff before uploading here)

[#3]

@amit_bhola 

I tried to send a file and it kept coming back undeliverable.  I did find the problem it was in my settings in properties, somehow got changed.  So it's all good now.

Thanks.