Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Excel as a Gradebook:Calculating sum excluding blanks and ze
I am attempting to use Excel as a gradebook and I would like to total the
values of a series of columns where the values are not blank and are greater than 0. Should I test each value in a range for blank or 0? If so, how would I go about doing that? I have basic programming skills based out of Java (very elementary), and would like to understand what I am doing. So if you reply, could you please explain? |
#2
|
|||
|
|||
Using Excel as a Gradebook:Calculating sum excluding blanks and ze
Hi!
I would like to total the values That means you want to add together or sum, correct? If so, the SUM function ignores blank cells and text entries, and any cells containing 0's will have no effect on a sum. So, you can probably just use something like this: =SUM(A1:D100) Biff "morgan.lintz" wrote in message ... I am attempting to use Excel as a gradebook and I would like to total the values of a series of columns where the values are not blank and are greater than 0. Should I test each value in a range for blank or 0? If so, how would I go about doing that? I have basic programming skills based out of Java (very elementary), and would like to understand what I am doing. So if you reply, could you please explain? |
#3
|
|||
|
|||
Using Excel as a Gradebook:Calculating sum excluding blanks and ze
But if my 'total' you mean count then use =COUNTIF(A1:A47,"0")
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "morgan.lintz" wrote in message ... I am attempting to use Excel as a gradebook and I would like to total the values of a series of columns where the values are not blank and are greater than 0. Should I test each value in a range for blank or 0? If so, how would I go about doing that? I have basic programming skills based out of Java (very elementary), and would like to understand what I am doing. So if you reply, could you please explain? |
#4
|
|||
|
|||
Using Excel as a Gradebook:Calculating sum excluding blanks an
Thank you for the info. My question was bout the sum, and I didn't realize
that the sum function ignored blank spaces. That's just what I needed. Now, will SUMIF(A1:F1, "0") not count anything that is zero or less than zero? "Biff" wrote: Hi! I would like to total the values That means you want to add together or sum, correct? If so, the SUM function ignores blank cells and text entries, and any cells containing 0's will have no effect on a sum. So, you can probably just use something like this: =SUM(A1:D100) Biff "morgan.lintz" wrote in message ... I am attempting to use Excel as a gradebook and I would like to total the values of a series of columns where the values are not blank and are greater than 0. Should I test each value in a range for blank or 0? If so, how would I go about doing that? I have basic programming skills based out of Java (very elementary), and would like to understand what I am doing. So if you reply, could you please explain? |
#5
|
|||
|
|||
Using Excel as a Gradebook:Calculating sum excluding blanks an
will SUMIF(A1:F1, "0")
not count anything that is zero or less than zero? Correct. Any values less than or equal to zero will not be included in the SUM. Biff "morgan.lintz" wrote in message ... Thank you for the info. My question was bout the sum, and I didn't realize that the sum function ignored blank spaces. That's just what I needed. Now, will SUMIF(A1:F1, "0") not count anything that is zero or less than zero? "Biff" wrote: Hi! I would like to total the values That means you want to add together or sum, correct? If so, the SUM function ignores blank cells and text entries, and any cells containing 0's will have no effect on a sum. So, you can probably just use something like this: =SUM(A1:D100) Biff "morgan.lintz" wrote in message ... I am attempting to use Excel as a gradebook and I would like to total the values of a series of columns where the values are not blank and are greater than 0. Should I test each value in a range for blank or 0? If so, how would I go about doing that? I have basic programming skills based out of Java (very elementary), and would like to understand what I am doing. So if you reply, could you please explain? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel, how do I replace cells containing blanks with nulls? | Excel Discussion (Misc queries) | |||
how do I reset the default sort order in excel xp back to blanks . | Excel Discussion (Misc queries) | |||
When Excel opens data is displayed and then blanks out. | Excel Discussion (Misc queries) | |||
excel needs feature to delete blanks when autofilter is used. | Excel Discussion (Misc queries) | |||
Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions |