Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
I have a register where I have to Insert a "1" if student is present and this
adds up at bottom of column as usual. If student is late I want to put "L" in the cell but I also want Excel to add these along with the number "1" as well?# Any ideas Thanks Steve King |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
On Jul 10, 9:22 am, K11ngy wrote:
I have a register where I have to Insert a "1" if student is present and this adds up at bottom of column as usual. If student is late I want to put "L" in the cell but I also want Excel to add these along with the number "1" as well?# Any ideas Thanks Steve King counta should do the trick. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
This should do what you want.
=COUNTIF(A:A,1)+COUNTIF(A:A,"L") HTH, Paul "K11ngy" wrote in message ... I have a register where I have to Insert a "1" if student is present and this adds up at bottom of column as usual. If student is late I want to put "L" in the cell but I also want Excel to add these along with the number "1" as well?# Any ideas Thanks Steve King |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
Another one:
=SUM(COUNTIF(A:A,{1,"L"})) Although, I bet I'd use PCLive's. K11ngy wrote: I have a register where I have to Insert a "1" if student is present and this adds up at bottom of column as usual. If student is late I want to put "L" in the cell but I also want Excel to add these along with the number "1" as well?# Any ideas Thanks Steve King -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
On Jul 10, 10:01 am, Dave Peterson wrote:
Another one: =SUM(COUNTIF(A:A,{1,"L"})) Although, I bet I'd use PCLive's. K11ngy wrote: I have a register where I have to Insert a "1" if student is present and this adds up at bottom of column as usual. If student is late I want to put "L" in the cell but I also want Excel to add these along with the number "1" as well?# Any ideas Thanks Steve King -- Dave Peterson counta's simplier. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
COUNTA counts non-blank cells and will not produce accurate results if there
are other cells in the range that contain data other than 1's or L's, . wrote in message ups.com... On Jul 10, 10:01 am, Dave Peterson wrote: Another one: =SUM(COUNTIF(A:A,{1,"L"})) Although, I bet I'd use PCLive's. K11ngy wrote: I have a register where I have to Insert a "1" if student is present and this adds up at bottom of column as usual. If student is late I want to put "L" in the cell but I also want Excel to add these along with the number "1" as well?# Any ideas Thanks Steve King -- Dave Peterson counta's simplier. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
On Jul 10, 10:43 am, "PCLIVE" wrote:
COUNTA counts non-blank cells and will not produce accurate results if there are other cells in the range that contain data other than 1's or L's, . wrote in message ups.com... On Jul 10, 10:01 am, Dave Peterson wrote: Another one: =SUM(COUNTIF(A:A,{1,"L"})) Although, I bet I'd use PCLive's. K11ngy wrote: I have a register where I have to Insert a "1" if student is present and this adds up at bottom of column as usual. If student is late I want to put "L" in the cell but I also want Excel to add these along with the number "1" as well?# Any ideas Thanks Steve King -- Dave Peterson counta's simplier. that wasn't in the specs. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
that wasn't in the specs.
Only the OP can tell but I expect that he might put a zero for a student who is not present and that would make your formula incorrect whereas the 2 other solutions will work regardless. -- Regards, Peo Sjoblom |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum in columns
Sorry, but I have to disagree. The OP clearly stated he wanted to add up
the number of ones and "L"s in a range. He did not say there would or could be anything else in the range (such as headings, subheadings, etc). So we have to assume. Using the COUNTA function can produce the wrong results if some of these other factors exist. But by using the COUNTIF function to count exactly what you are looking for, you reduce the possibility of incorrect results. wrote in message ups.com... On Jul 10, 10:43 am, "PCLIVE" wrote: COUNTA counts non-blank cells and will not produce accurate results if there are other cells in the range that contain data other than 1's or L's, . wrote in message ups.com... On Jul 10, 10:01 am, Dave Peterson wrote: Another one: =SUM(COUNTIF(A:A,{1,"L"})) Although, I bet I'd use PCLive's. K11ngy wrote: I have a register where I have to Insert a "1" if student is present and this adds up at bottom of column as usual. If student is late I want to put "L" in the cell but I also want Excel to add these along with the number "1" as well?# Any ideas Thanks Steve King -- Dave Peterson counta's simplier. that wasn't in the specs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |