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!

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!

In H8 enter the following: =IF(B:B="D",SUM(F:F),"") This function will sum
column F if Column B is letter D, and if not it will be blank.
In H9 enter the following =IF(B:B="J",SUM(F:F),"") This function will sum
column F if Column B is letter J, and if not it will be blank.

I think you need to specify which cells in column F to sum and which cells
in column B to look at for your letters.

HTH
JAKE

"joaniemic" wrote:

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 http://www.microsoft.com/wn3/aspx/po...loc=en-US&tt=2
which would be the same except for what is in Column B is the letter J.)

Thanks so much!