- To post as a guest, your comment is unpublished.· 21 days agoYou can try this formula =SUMPRODUCT(ISFORMULA(A1:A100)*A1:A100)
How to sum column values until next blank cell in Excel?
For instance, you have a list of values, and there is a blank cell in the list to break the list into two parts, and you just want to sum the values until the blank cell appears in the list as below screenshot shown, and how can you quickly calculate it in Excel?
Here is a formula I can introduce for solving this problem in Excel.
Select a blank cell which you will place the calculated result into, type this formula, =SUM(A1:INDEX(A1:A100,MATCH(TRUE,(A1:A100=""),0))), press Shift + Ctrl + Enter keys to get the calculation correctly. See screenshot:
In the formula, A1 is the first cell in the list you want to calculate, and A1: A100 is the list range you use, you can change them as you need.
|Kutools for Excel: The 200 functions you must have in Excel, you can free download from here|
You are guest
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 1 months agoim looking for the same answer, how to do this to count UP instead of down
- To post as a guest, your comment is unpublished.· 4 months agoGreat formula, thank you. Is it possible to change the formula, so that it will be counting upwards? Relating to the example, 902 will be the outcome in cell B10 (instead of B1)
- To post as a guest, your comment is unpublished.· 1 years agoThanks this worked really well. Saved me a ton of time!
- To post as a guest, your comment is unpublished.· 1 years agoThis isn't even the right answer smfh
- To post as a guest, your comment is unpublished.· 3 days agoYes it is. 451+64+71+70+25+44+65+88+24=902