Help please ...
I've got a formula that works dandy. But when I modify it to incorporate some changes, it won't work any longer. I don't know why. I've attached the before and after.
If one of you gracious folks can point out where I went wrong, I would be very grateful.
Here's the original Fromula:
=SUMIF(A5:A93,"CO",D5:D93)+SUMIF(A5:A93,"CH",D5:D93)
The formula watches column A for any entries which read "CO" or CH" ... then it will add the totals from there in Column D.
With the new formula, I added a couple of new categories. In addition to "CO, CH, there's also "HC"
=SUMIF(A5:A93,"CO",D5:D93)+SUMIF(A5:A93,"CH",D5:D93)+SUMIF(A5:A93,"HC",D5:D93)
When I enter the new, longer format, it only enters it into the cell as type ... not as a format. I tried Holding the CTRL+ENTER keys down, but that still didn't work.
Am I doing something wrong here? Please help.
Kevin.
I've got a formula that works dandy. But when I modify it to incorporate some changes, it won't work any longer. I don't know why. I've attached the before and after.
If one of you gracious folks can point out where I went wrong, I would be very grateful.
Here's the original Fromula:
=SUMIF(A5:A93,"CO",D5:D93)+SUMIF(A5:A93,"CH",D5:D93)
The formula watches column A for any entries which read "CO" or CH" ... then it will add the totals from there in Column D.
With the new formula, I added a couple of new categories. In addition to "CO, CH, there's also "HC"
=SUMIF(A5:A93,"CO",D5:D93)+SUMIF(A5:A93,"CH",D5:D93)+SUMIF(A5:A93,"HC",D5:D93)
When I enter the new, longer format, it only enters it into the cell as type ... not as a format. I tried Holding the CTRL+ENTER keys down, but that still didn't work.
Am I doing something wrong here? Please help.
Kevin.