Maybe just:

=IF(count(C8:c15)<8,"",SUM(C8:C15))

=count() counts numbers. If your users can type text in those cells:

=IF(counta(C8:c15)<8,"",SUM(C8:C15))

=counta() counts numbers and text.


thomasstyron wrote:

Hello All:

I have this formula:

=IF(C8*C9*C9*C10*C11*C12*C13*C14*C15=0,"",SUM(C8:C 15))

How can I condense this group, C8*C9*C9*C10*C11*C12*C13*C14*C15, to the
same type of notation as the grouping of C8, C9, C10, …C15 =(C8:C15)? Is
there a way to specify, “if this cell or this cell or this cell etc.” a
shorter way, or do we just have to type out the whole shebang?

Thanks in advance for any help that can be offered.
Best regards to all,
Thomas

--
thomasstyron
------------------------------------------------------------------------
thomasstyron's Profile: http://www.excelforum.com/member.php...o&userid=25568
View this thread: http://www.excelforum.com/showthread...hreadid=393933

--

Dave Peterson