What formula do you use to calculate cells but skipping cells that don't have any info in them? ie =sum(b2,b5,b7,b9) but sometimes some cells won't have any info. Can i add a kind of "skip if blank"?
by 
Julielo
ANSWERS: 4
-
Assuming you're using Excel, that should happen automatically. Open a test book and fill column A with values, but skip a few cells. Say, A1 - A8. In another cell, type in =sum(A1:A8) You'll notice that Excel calculates the sum accurately, even though some of the cells in the range are empty. If you later add a number into one of the empty cells or delete an existing value, the summed total should change to reflect the modification.
-
I could be wrong as it was quite sometime ago when I did this and I don't have a copy of Excel installed at the moment. However, if a cell is blank then it's value is Null (and not zero). Look in the Help (F1) and search for the term: If IsNull. The skip if blank process translates into a conditional 'if statement' and examples will be in the help. Does this help at all or would you like me to see if I can find out properly (so to speak)?
-
thank you both for your answers. I appreciate it. When I am calculating the days in team 3/11/08 and out of team 3/13/08 that's 3 days but if I also calculate the out of team time (ie 3/13-3/15)it adds the 13th again so was adding that day twice. I added -1 to the formula and that fixed it, but that -1 is in all formulas where a # might be so if there's no info I get a -1. When I sum all those fields the -1 messes things up. Sorry hard to explain. I will do a search on the If Null and see if i can figure it out.
-
If there is no value in a cell it won't be added to the total, so if you have a series of figures in, say, A1:A10 and some of them are blank (null), SUM(A1:A10) will give the right result.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC