|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Any way to ignore neighboring cell while ignoring blank cells in SUMPRODUCT?
I normally use Excel to calculate my current grade in a class but I am wondering if there is any way to ignore a weight in a calculation? (for example, ignore the 20% I have listed for Final Exam, as I clearly won't need that in a calculation because I will not have that grade until the end of the semester)
Right now, the formula I have with the Final Grade takes into account all of the weights, so the grade is marginally lower because it is still taking the weight into account and essentially substituting a zero in when the grade cell is blank. Is there any way to fix this so that, for example, if I only had a 90 in one section, attendance for example, the grade would be 90 and not 13.5 (90*.15, the weight)? Attached is a .png of my sheet right now. I also understand why I have div/0 errors, as I have no grades in for the cells that those cells with an error are averaging. |
#2
|
||||
|
||||
Hi and welcome
could you please explain another way what you are trying to do ? I don' understand at all. ( and also posting a sheet instead of an image helps)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C | rick10r | Excel | 1 | 07-05-2016 12:07 PM |
Formulato say if cell is blank do this, if not blank do this. | mbesspiata | Excel | 1 | 01-17-2015 05:02 AM |
What is the right IF function to use to sum the last above cell has value and ignore zero? | MGadAllah | Excel | 1 | 07-15-2014 08:59 AM |
How to ignore a mail merge field if the field is blank | redzan | Mail Merge | 1 | 05-16-2013 08:34 AM |
How to ignore the in between cells? | babapusy | Excel | 1 | 01-21-2013 03:05 AM |