Multipy the number of cells with any text (ie Names) by another cell with a number (ie Dollar value)

[Moaman]

Hi, I am working out the cost of putting people on training courses . I have a list with peoples names in some cells in this list and other cells in the same list are blank. Then above the list is the course cost in dollars. I need a formular ignor blank cells and to "see" that a list has different text (i.e. Names) in cells and then multiply those with the course cost in the cell above the list. I tried =IF(ISTEXT(K31:K42),1,(*K29)) but just got a SPILL error back. I think I'm nearly there but if anyone can advise I be very grateful.

 

[duggie33]

Hi Moaman,

If I understand correctly, you want the course cost multiplied by the number of names in the list. Try this formula:

=COUNTIF(K31:K42,"*")*K29

I hope that helps,

Doug

 

[Moaman]

Hi Moaman,

If I understand correctly, you want the course cost multiplied by the number of names in the list. Try this formula:

=COUNTIF(K31:K42,"*")*K29

I hope that helps,

Hi Doug,
Thanks so much that is perfect. Your a Ledgend.

 

[duggie33]

Haha, many here have much more knowledge than me. Glad to help.

 

[Peter_SSs]

If that one works for you then so should this

=COUNTA(K31:K42)*K29