Conditional Format

[joaniemic]

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!

 

[Pete_UK]

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

 

[JBoyer]

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