Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total colum using x instesd of numbers what is the formula
Doing a attendence roster. want to use x instead of a number. Don't know the
formula. could use some help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total colum using x instesd of numbers what is the formula
If x has been entered into cells in a column and you want to count the number
of x's then try: =COUNTIF(A1:A7,"x") -- Gary''s Student "Chopper-One" wrote: Doing a attendence roster. want to use x instead of a number. Don't know the formula. could use some help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total colum using x instesd of numbers what is the formula
Chopper-One, how about something like this,
=COUNTIF(A1:A10,"x") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Chopper-One" wrote in message ... Doing a attendence roster. want to use x instead of a number. Don't know the formula. could use some help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total colum using x instesd of numbers what is the formula
Chopper-One Wrote: Doing a attendence roster. want to use x instead of a number. Don't know the formula. could use some help webdings font r will give you an X -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519183 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to sum total numbers with dashes in them | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
Displaying numbers used in formula | Excel Discussion (Misc queries) |