Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total only those cells with Sum totals
Hello - I knew I forgot something in my previous question!
As I said in an earlier post In column J, I have a series of cells I want to sum at the first blank. ie 4 5 8 (blank) 8 0 2 5 (blank) I want those blanks to sum the previous few cells, and to be bold. Then - How can I get a total at the end of the column of ONLY those cells with a sum in them? Sorry about two posts - trying to do too many things at once :) Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total only those cells with Sum totals
Assume your values start in J2, in K2 put
One way =IF(J2="",SUM($J$2:J2)-SUM($K$1:K1),"") copy down then format as bold or select the second column and use formatconditional formatting cell value not equal to ="" then format bold font -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Bleu_808" wrote in message oups.com... Hello - I knew I forgot something in my previous question! As I said in an earlier post In column J, I have a series of cells I want to sum at the first blank. ie 4 5 8 (blank) 8 0 2 5 (blank) I want those blanks to sum the previous few cells, and to be bold. Then - How can I get a total at the end of the column of ONLY those cells with a sum in them? Sorry about two posts - trying to do too many things at once :) Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total only those cells with Sum totals
This worked for me! Thanks so much!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
getting a total for a row of cells where some are text | Excel Discussion (Misc queries) | |||
how do I add cells totals | Excel Discussion (Misc queries) | |||
I want to only at cells that are in bold to a total in Excel | Excel Discussion (Misc queries) | |||
calculate which cells in column A will give me the total of column | Excel Worksheet Functions |