| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I do a summation with text instead of numbers?
I'm trying to do a summation of an attendance sheet. I have an "x" marked
for the fact that they were there, but I don't know how to format that into a number so I can do a sum and show that they were there this many times. Any thoughts? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a summation with text instead of numbers?
=COUNTIF(A:A,"x")
-- Gary''s Student - gsnu200770 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I do a summation with text instead of numbers?
=SUMPRODUCT(--(A1:A10="x"))
Regards, Ryan-- -- RyGuy "Gary''s Student" wrote: =COUNTIF(A:A,"x") -- Gary''s Student - gsnu200770 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summation | Excel Discussion (Misc queries) | |||
| summation | Excel Worksheet Functions | |||
| Summation Operator | Excel Worksheet Functions | |||
| Summation from a to b | Excel Worksheet Functions | |||
| How can perform a summation? | Excel Worksheet Functions | |||
Linear Mode
