View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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!