| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Would like one cell to both count and multiply a range of cells
a b c d e f g 2 3 4 5 6 25 would like the formula to count the numbers left in rows (a thru f) and then multiply that number by 5 (row g) which in this case would come to 25. I need row (g) to do both funtions. Thank You |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Would like one cell to both count and multiply a range of cells
Try this:
=COUNT(A1:F1)*5 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "golfer18" wrote in message ... a b c d e f g 2 3 4 5 6 25 would like the formula to count the numbers left in rows (a thru f) and then multiply that number by 5 (row g) which in this case would come to 25. I need row (g) to do both funtions. Thank You |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Would like one cell to both count and multiply a range of cell
Thanks RD. For some reason I had to use "COUNTA" instead of COUNT. Anyways it
worked great . Thanks again Golfer18 "Ragdyer" wrote: Try this: =COUNT(A1:F1)*5 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "golfer18" wrote in message ... a b c d e f g 2 3 4 5 6 25 would like the formula to count the numbers left in rows (a thru f) and then multiply that number by 5 (row g) which in this case would come to 25. I need row (g) to do both funtions. Thank You |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Count the occurance of a value x a value in another cell in excel | Excel Worksheet Functions | |||
| COUNT IF NOT EQUAL TO ZERO | Excel Worksheet Functions | |||
Hybrid Mode
