| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing data in columns
Use Countif instead of Sumif.
Hope that this is what you are looking for€¦ Assume that you are having the Gender details in A Column. A COL M F M F M M F M =COUNTIF(A:A,"M") =COUNTIF(A:A,"F") If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "ElGordo" wrote: I have data in letter form: M=male and F= female. I have tried SUMIF but cant get a total of aal the "M"s or"F"s in a column.What am I doing wrong as the help pages dont ma ke it clear? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditionally summing data from two columns depending on their value. | Excel Worksheet Functions | |||
| summing columns if there is data | Excel Worksheet Functions | |||
| summing data in several columns | Excel Discussion (Misc queries) | |||
| summing columns | Excel Worksheet Functions | |||
| Summing Columns | Excel Worksheet Functions | |||
Threaded Mode
