Member Avatar for Stagnant

Cell C4 has the expression

=565+660+709+1093

Is there a function/nest of functions that can output the number of values being added? BIG NOTE: I AM NOT ASKING FOR THE SUM OF THE EXPRESSION!

  • 2 Contributors
  • 1 Reply
  • 180 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for rch1231

Not that I have ever seen. If the values were in different cells then you can find out how many cells had values. The only way I can think of that might work is to count the number of "+" symbols in the formula and add 1.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.