|
help with count
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 -- Nisha P |
help with count
Right click in the status bar and select Sum.
-- Biff Microsoft Excel MVP "nishkrish" wrote in message ... 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 -- Nisha P |
help with count
Right-click the Status Bar - choose SUM
George Gee "nishkrish" wrote in message ... 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 -- Nisha P |
help with count
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. -- Nisha P "George Gee" wrote: Right-click the Status Bar - choose SUM George Gee "nishkrish" wrote in message ... 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 -- Nisha P |
help with 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 "nishkrish" wrote: 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. -- Nisha P "George Gee" wrote: Right-click the Status Bar - choose SUM George Gee "nishkrish" wrote in message ... 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 -- Nisha P |
help with count
No Francis it didnt help me it returns the value that is there in that cell
-- Nisha P "Francis" wrote: 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" wrote: 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. -- Nisha P "George Gee" wrote: Right-click the Status Bar - choose SUM George Gee "nishkrish" wrote in message ... 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 -- Nisha P |
help with count
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 "nishkrish" wrote: No Francis it didnt help me it returns the value that is there in that cell -- Nisha P "Francis" wrote: 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" wrote: 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. -- Nisha P "George Gee" wrote: Right-click the Status Bar - choose SUM George Gee "nishkrish" wrote in message ... 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 -- Nisha P |
| All times are GMT +1. The time now is 12:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com