“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have names down my column B and the linear feet of the item in J .. how do I track the linear feet in J based on the name in column B .. Example, Lilly - 7 Mike - 8 Dolly -7 Lilly - 7 (and I want the total beside Lilly to update to 14 total in the graph)

Solved by E. W. in 11 mins

I need a formula to figure cubit feet from measurements taken in feet

Solved by A. B. in 20 mins

Create a range name for cells O3:P7 on the Homes Sales Data worksheet. The name should be Your last name plus the word Realty. In Column M, find the Realty Company from the lookup table in cells O3:P7. In cell P3, change the Realty Name to your last name Realty. Use the VLOOKUP command to calculate. So, home with square footage from: a.0 to less than 1200 feet, go to (Your Name) Realty b.1200 to less than 1800 feet, go to Florida Homes c.1800 to less than 2500 feet, go to Arturos Realty d.2500 to less than 3000 feet, go to Palm Builders e.Homes with 3000 feet or more, go to Sunshine Developers

Solved by V. Y. in 30 mins

I calculate employee commission based on a certain amount of square feet they install. We have created input fields for the calculations and each employee has their own calculation row for a specific job. Right now we enter in the amount of sq feet on the calculations page then copying the commission to the employee worksheet. Is it possible to just enter in the number of Sq feet on the employee worksheet and then have Excel do a lookup and calculate the right commission and put the commission amount next to the sq feet amount?

Solved by G. U. in 11 mins

i have cell E5 & F5 to imput either quantity in pieces or in total linear feet to show in cell A5, so far i have the 2 conditions when input is in E5 this is the formula =IF(E5>0,E5*21," ") , when input is in F5 this is the formula =IF(F5>0,ROUNDUP(F5/21,0)*21," ") ,what i am trying to do is the following : the formula should only allow 1 input from either E5 or F5

Solved by O. W. in 13 mins