Conditional Format
I think you mean that you need a formula like this in H8:
=SUMIF(B:B,"D",F:F)
and this in H9:
=SUMIF(B:B,"J",F:F)
This is not conditional formatting (which affects the way a cell looks
depending on some condition) but is a conditional sum.
Hope this helps.
Pete
"joaniemic" wrote in message
...
I would appreciate help with the following. I need to enter a conditional
format in Cell H8:
The amount in cell H8 needs to be the sum of the amounts in Column F IF
what is in Column B is the letter D. (Another formula is needed for Cell
H9
which would be the same except for what is in Column B is the letter J.)
Thanks so much!
|