Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel: Calculation for all rows in one column

Status
Not open for further replies.
bethabernathy

bethabernathy

Programmer
Jul 13, 2001
254
MX
Hi - This is probably very simple, but for some reason, I can't figure out how to do it. I need to sum F:4 to
F:1843 *27% for each row and put the % into H:4 to H1843 for each row. Is this possible to do without performing the calculation in each cell? Thanks, Beth



beth@integratedresourcemgmt.com
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
1K
combo
combo
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
371
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
511
mintjulep
M
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
873
bs6600
bs6600
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
451
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top