Help on an IF formula

[Gerard Sanchez]

Hi,

Here's what I am trying to do:

What I am trying to do is that IF ranges C20:C53, F20:F53, and I20:I51 are
all blank-- I not am talking about zero value, but no value/blank
cells--then SUM these ranges (B20:B53,E20:E53,H20:H51). But if ranges
C20:C53, F20:F53, and I20:I51 are not blank, put in the text "NOT BALANCED."

Here's the IF formula I came up with:

=IF(ISBLANK(C20:C53,F20:F53,I20:I51),SUM(B20:B53,E20:E53,H20:H51),"NOT
BALANCED !")

Here's the Result:

"To many arguments" error. I realized that ISBLANK function can only refer
to only one cell at a time. So no luck.


Does anybody have any ideas how to translate what I am trying to do into a
formula?

Thanks

 

[T. Valko]

It's not real clear what you mean by: if [the] ranges are not blank.

Does that mean if *every* cell is not blank?

See if this does what you want:

=IF(COUNT(C20:C53,F20:F53,I20:I51)=0,SUM(B20:B53,E20:E53,H20:H51),"Not
Balanced")

 

[Gerard Sanchez]

YES! That worked!

Here I was, going through Alot of different function going about the
problem.

Thank you soo much T.

--Gerard

It's not real clear what you mean by: if [the] ranges are not blank.

Does that mean if *every* cell is not blank?

See if this does what you want:

=IF(COUNT(C20:C53,F20:F53,I20:I51)=0,SUM(B20:B53,E20:E53,H20:H51),"Not
Balanced")

--
Biff
Microsoft Excel MVP

Hi,

Here's what I am trying to do:

What I am trying to do is that IF ranges C20:C53, F20:F53, and I20:I51
are all blank-- I not am talking about zero value, but no value/blank
cells--then SUM these ranges (B20:B53,E20:E53,H20:H51). But if ranges
C20:C53, F20:F53, and I20:I51 are not blank, put in the text "NOT
BALANCED."

Here's the IF formula I came up with:

=IF(ISBLANK(C20:C53,F20:F53,I20:I51),SUM(B20:B53,E20:E53,H20:H51),"NOT
BALANCED !")

Here's the Result:

"To many arguments" error. I realized that ISBLANK function can only
refer to only one cell at a time. So no luck.


Does anybody have any ideas how to translate what I am trying to do into
a formula?

Thanks

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

YES! That worked!

Here I was, going through Alot of different function going about the
problem.

Thank you soo much T.

--Gerard

It's not real clear what you mean by: if [the] ranges are not blank.

Does that mean if *every* cell is not blank?

See if this does what you want:

=IF(COUNT(C20:C53,F20:F53,I20:I51)=0,SUM(B20:B53,E20:E53,H20:H51),"Not
Balanced")

--
Biff
Microsoft Excel MVP

Hi,

Here's what I am trying to do:

What I am trying to do is that IF ranges C20:C53, F20:F53, and I20:I51
are all blank-- I not am talking about zero value, but no value/blank
cells--then SUM these ranges (B20:B53,E20:E53,H20:H51). But if ranges
C20:C53, F20:F53, and I20:I51 are not blank, put in the text "NOT
BALANCED."

Here's the IF formula I came up with:

=IF(ISBLANK(C20:C53,F20:F53,I20:I51),SUM(B20:B53,E20:E53,H20:H51),"NOT
BALANCED !")

Here's the Result:

"To many arguments" error. I realized that ISBLANK function can only
refer to only one cell at a time. So no luck.


Does anybody have any ideas how to translate what I am trying to do into
a formula?

Thanks