help with count

[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

 

[T. Valko]

Right click in the status bar and select Sum.

 

[George Gee]

Right-click the Status Bar - choose SUM

George Gee

 

[nishkrish]

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.

 

[Francis]

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

 

[nishkrish]

No Francis it didnt help me it returns the value that is there in that cell

 

[Francis]

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