Sumif for criteria in one column not adding up I am just starting Excel (1 week in) and have to add these criteria. I used =countif(A15:A19,"moderatelyincreased") as the formula and got zero which it is obviously not correct. I tried =SUMIF(A15:A19,"moderatelyincreased") and failed. I am not sure if it is spacing or if I don't have the right formula, but I am clueless at this point. Can someone guide me. Greatly appreciate. This assignment is due Sunday, Lynette