if statement

[RichardO]

Hello all:

Please help with the following:

I have 2 columns D and J.

row 1 and 2 are headers.

I would like an if statement that would add rows of column J is th
corresponding rows are blank in column D.

E.g. if D3, D4 and D7 are blank. In cell I1, I would like to ad
J3+J4+J7 together.

Can you please show me how to go about this?

Thanks everyone.

Richard

 

[Ashish Mathur]

Hi,

Try this - SUM(IF(AND(J3="",J4="",J7=""),D37),0)

Regards,

Ashish Mathur

 

[Frank Kabel]

Hi
so if for example D4 is not blank you want to add only D3 and D7?. If
yes try:
=D3*(J3="")+D4*(J4="")+D7*(J7="")

 

[RagDyeR]

Try this

=SUMIF(D3100,"",J3:J100)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hello all:

Please help with the following:

I have 2 columns D and J.

row 1 and 2 are headers.

I would like an if statement that would add rows of column J is the
corresponding rows are blank in column D.

E.g. if D3, D4 and D7 are blank. In cell I1, I would like to add
J3+J4+J7 together.

Can you please show me how to go about this?

Thanks everyone.

Richardo