Excel - sum to = 1 for each cell
Asked By Mike
21-Nov-09 01:31 PM
I am trying to sum up 37 cells to = 1 each for each cell ex. if i put say 997
in cells i want them to = 1 each so that the sum total = 37 if i put 997 or
any other # in cells
Bernie Deitrick replied to Mike
Mike,
Sorry, that just is not clear. Perhaps a formula
=SUM(A1:A37)/A1
where A1 to A37 have your number 997?
Bernie
Joe User replied to Mike
Count and Sum functions with 2 criterias Excel Question: Category Processed (Yes) Not Processed(No) Count Sum(Amt) Count Sum(Amt) 1 - 25 26 - 50 51 - 100 101 - 250 Total Data has two columns which are Amount and Status(Yes / No). Can someone help me with the formulae to count the number of coumns which fall in each Category and also sum of the amounts in those categories? - - Sue Excel Worksheet Discussions SUMPRODUCT (1) Workbook (1) VLOOKUP
Status bar showing sum and count Excel I have to do lot ofselection and check sum and count. Status bar in excel shows sum and count one at a time. Is there a way, status bar shows sum and count both? Regards, Madiya Excel Programming Discussions WorksheetFunction (1) Application (1) Excel (1) Range (1) Madiya
excel count / sum Excel Is is possible to subtotal on amount and count the number of entries (excluding sum total). I tried do this in a macro and can only display either the sum or the count of my checks not both. Which is what I need. There are several types of checks and I need to be able to Subtotal type but also give a count of the each type. Thanks - - Millers Excel Programming Discussions Macro (1) Millers (1) Botha (1 you say it will be easy to alter to provide botha sun total and a count of the num ber of items in each sub total. Paul Smith I figured it
Lost sum, count, averge, etc shortcut window Excel Hello, I have no idea how, but i seem to bar of Excel. The ones where you can highlight cells, right mouse click and select Sum, Count, Average, etc. The value then appears in the bottom scrool bar section of the screen Window (1) View> status bar - - Regards, Peo Sjoblom Ah! Thanks! : ) - - Thank you - - Suzanne. keywords: Lost, sum, count, averge, etc, shortcut, window description: Hello, I have no idea how, but i seem to
subtotals that break on date & give count & sum ($$ col) Excel I have a worksheet that is sorted on date column. I want to subtotals when ever the date changes of count of dates and sum of amount column. I can get the count to work but I cannot seem to find how to add the amount subtotal on the same row as the count subtotals. Excel Worksheet Discussions Microsoft Excel (1) Worksheet (1) Hi, Create a pivot table. Drag Ashish Mathur Microsoft Excel MVP www.ashishmathur.com keywords: subtotals, that, break, on, date, &, give, count, &, sum, ($$, col) description: I have a worksheet that is sorted on date column. I want to