|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 27th, 2009, 08:07 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 
|
|
#2
March 27th, 2009, 08:48 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#3
March 27th, 2009, 08:51 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#4
March 28th, 2009, 12:49 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#5
March 28th, 2009, 03:54 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#6
March 31st, 2009, 01:39 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#7
March 31st, 2009, 08:50 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
