help with count

  • Thread starter Thread starter nishkrish
  • Start date Start date
N

nishkrish

I have data in cells when i highlight those cells it shows count 20 or count
30 but i want it to show the total value of those cells.


Eg column d1 has 500
d2 1000
d3 200

it should show med 1700 and not count 3

Please help
 
its already enabled i guess the data i am copying pasting from website is
pasting as values when i change the column to number of currency it still
doesnt show me the sum it olny shows count.
 
check that it is formatted as currency
use this to test, if it is text, it will return the text in D1,otherwise it
will return blank
=T(D1)
If it is a text, format your cells as Currency

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
if this doesn't return a blank, then it is a text
try =Value(D1) to change the text look-like number to number

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
Back
Top