Skipping a cell when calculating a total
Closed
Starhawk85
-
Apr 23, 2010 at 06:34 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 25, 2010 at 08:56 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 25, 2010 at 08:56 PM
Related:
- Skipping a cell when calculating a total
- Total war warhammer 3 free download - Download - Strategy
- Total copy - Download - File management
- Total video converter free download - Download - Video converters
- Formula for calculating position in excel ✓ - Excel Forum
- How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
7 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 24, 2010 at 06:32 AM
Apr 24, 2010 at 06:32 AM
Then in this case, use this formula
=SUM(B6:H6)/SUMPRODUCT((B$2:H$2) * (B6:H6<>""))
or
=SUM(B6:H6)/SUMIF(B6:H6,"<>",B$2:H$2)
This finds the average based on the the cells that are populated.
=SUM(B6:H6)/SUMPRODUCT((B$2:H$2) * (B6:H6<>""))
or
=SUM(B6:H6)/SUMIF(B6:H6,"<>",B$2:H$2)
This finds the average based on the the cells that are populated.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 23, 2010 at 07:30 PM
Apr 23, 2010 at 07:30 PM
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
starhawk85
Posts
16
Registration date
Friday April 23, 2010
Status
Member
Last seen
April 27, 2010
1
Apr 23, 2010 at 08:24 PM
Apr 23, 2010 at 08:24 PM
i have cells [_] [_] [_] following this direction>>>> e1-f1-g1
if it looks like this [23] [_] [_] i need the formula to skip over the blank cells when calculating to give me my total
they can not have 0 in them because 0 is being used other wise
but if the cells are to have #'s like 5 or 10 or 12 ant etc. in them when added like so [23] [12] [_] they need to be added to the calculation to the total while still avoiding adding the blank cell to the total
it needs to only calculate the total within the cells that have numbers in them so its not adding the blank cells as part of the total .... its kina complicated i guess
if it looks like this [23] [_] [_] i need the formula to skip over the blank cells when calculating to give me my total
they can not have 0 in them because 0 is being used other wise
but if the cells are to have #'s like 5 or 10 or 12 ant etc. in them when added like so [23] [12] [_] they need to be added to the calculation to the total while still avoiding adding the blank cell to the total
it needs to only calculate the total within the cells that have numbers in them so its not adding the blank cells as part of the total .... its kina complicated i guess
starhawk85
Posts
16
Registration date
Friday April 23, 2010
Status
Member
Last seen
April 27, 2010
1
Apr 23, 2010 at 08:36 PM
Apr 23, 2010 at 08:36 PM
here it is the section im trying to get this to work on is in I there are a few diff codes in each one i have a bunch more but these are what come closest to working but its just not happening ...
https://authentification.site/files/22094257/gradebook.xlsb
https://authentification.site/files/22094257/gradebook.xlsb
Didn't find the answer you are looking for?
Ask a question
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 23, 2010 at 10:26 PM
Apr 23, 2010 at 10:26 PM
You have so many different formulas in it. what exactly are you trying to do
From what I can see,
either you are trying to add to total score and divide it by total maximum possible score
=sum(b8:h8) /sum(b2:h2)
or you are trying to weighted score
=SUMPRODUCT((B8:H8)/(B$2:H$2))/COUNT(B$2:H$2)
If you are looking for some thing else, could you explain about what sort of calculation
From what I can see,
either you are trying to add to total score and divide it by total maximum possible score
=sum(b8:h8) /sum(b2:h2)
or you are trying to weighted score
=SUMPRODUCT((B8:H8)/(B$2:H$2))/COUNT(B$2:H$2)
If you are looking for some thing else, could you explain about what sort of calculation
starhawk85
Posts
16
Registration date
Friday April 23, 2010
Status
Member
Last seen
April 27, 2010
1
Apr 23, 2010 at 11:01 PM
Apr 23, 2010 at 11:01 PM
reason for the diff formulas is just my testing them out
i am wanting to add to total score and divide it by total maximum possible score
but if there is a blank cell i need to read it as if it did not exist
or
if there is a blank cell i want it to read the possible score in the total
to provide a current grade...
for example assignment one has been done and now currently working on assignment 2
lets say assignment 1 has a possible points of 30 and i have received 30 points for it my grade should read as 100% A even though assignment 2,3,4,5..etc have no points entered in.
really simply the question asked is what is my grade so far with the assignments we have done.
i guess i need the cells that have nothing entered to = the possible points without showing in the individual cells. and still get a correct % and grade letter..
i am wanting to add to total score and divide it by total maximum possible score
but if there is a blank cell i need to read it as if it did not exist
or
if there is a blank cell i want it to read the possible score in the total
to provide a current grade...
for example assignment one has been done and now currently working on assignment 2
lets say assignment 1 has a possible points of 30 and i have received 30 points for it my grade should read as 100% A even though assignment 2,3,4,5..etc have no points entered in.
really simply the question asked is what is my grade so far with the assignments we have done.
i guess i need the cells that have nothing entered to = the possible points without showing in the individual cells. and still get a correct % and grade letter..
starhawk85
Posts
16
Registration date
Friday April 23, 2010
Status
Member
Last seen
April 27, 2010
1
Apr 25, 2010 at 08:54 PM
Apr 25, 2010 at 08:54 PM
perfects thank you tons!
StarhawkArts.com
Art Has No Limits!
StarhawkArts.com
Art Has No Limits!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 25, 2010 at 08:56 PM
Apr 25, 2010 at 08:56 PM
Post your book. Also put the formula that you are using. as well hard code the values that are the formula should have given you.