| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
