Search results

I am trying to create an IF/AND formula based on multiple factors but I am getting confused and cannot get the formula to do everything I need it to do. I have only been using the IF/AND formula for 4 months so I am pretty new at what all it can do and have a lot to learn. I need an IF/ANDF...

I am trying to create a sum formula that will search within a table and sum the total number of hours for each employee by month by account code. Every SUMIF formula I have tried comes back with an error message or it will only pick up the first row of an employee account code but if the...

IT WORKED! THANK YOU VERY, VERY MUCH. I had been trying to figure this out for two weeks!!

I just tried the formula recommended here and it worked but it gave me the return value for Column E vice Column C. The months of the Pivot table I need the return value for in my current worksheet was in Column B through E. Column B Employee ID Column C (May) Column D (Jun) Column E...

I did do many searches on VLOOKUP but I did not see what I was looking for. I will try this and hopefully it will work. Thanks for welcoming me and helping me with this.

I am trying to find the weighted average of hourly labor costs. I have never tried this in Excel but I know their must be a way. I tried the sumproduct formula but the result is coming out just like the average formula which is not what I want. Example: Hours Hrly Cost 360 109.11...

We just migrated to Excel 2010 and I cannot no longer drag my original formula horizontally across rows and get values. I keep getting an N/A# or REF #. My workbook have employee ID number, and I do a vlookup by employee ID number to get their monthly costs incurred. For example...

I am a Project Controller who have worked in many different facets of accounting for the last 15 years. I stumbled across this site and have been surfing it for awhile then decided to join because everyone seems so helpful. I live in the southeast. My favorite hobbies are sutdying th bible...