Help with a formula

[Travisallen2007]

I am looking for some assistance with a formula.

I need it to say if there is text in g11 through g15 I need it to calculate 192*(each field with a text entry) in cell H22.


Example: (This would be 192*3 since three of the 5 cells have text so H22 would read 576)

[TABLE="width: 500"]
<tbody>[TR]
[TD]James[/TD]
[/TR]
[TR]
[TD]Nancy[/TD]
[/TR]
[TR]
[TD]Frank[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Try:

[TABLE="width: 332"]
<colgroup><col width="332"></colgroup><tbody>[TR]
   [TD="width: 332"]=SUMPRODUCT(--(ISTEXT($G$11:$G$15)))*192
[/TD]
 [/TR]
</tbody>[/TABLE]

 

[Travisallen2007]

Perfect! Thanks.

 

[jtakw]

Hi,

A little simpler without Sumproduct:

Book1
	G	H
11	5
12	James
13	Nancy
14
15	Frank
16
22		576
Sheet191

Cell Formulas
Range	Formula
H22	=COUNTIF(G11:G15,"*")*192