#1
|
|||
|
|||
SumIF with non-adjacent cells
Hello and thanks for the help. I attached a picture of my spreadsheet. I hope it helps.
I am tracking hours for 3 different projects in Excel using the codes IT, HR, and B. In column P I want to count the hours that have been assigned to the IT Project, In column R, count the hours for HR and in column T, count the B hours. Columns v through AG will collect the hours and assign the project code. In columns V and W I will sign in and sign out, column X will calculate the number of hours for V&W, and in column Y I will assign the code of IT, HR, or B to the hours. In columns Z and AA I will sign in and sign out, column AB will calculate the number of hours for Z&AA, and in column AC I will assign the code of IT, HR, or B to the hours. In columns AD and AE I will sign in and sign out, column AF will calculate the number of hours for AD&AE, and in column AG I will assign the code of IT, HR, or B to the hours. I need help figuring out how to create a formula in column P to add only the IT hours found in columns X, AB and AF based on the codes in Y, AC and AG; then in column R add only the HR hours found in columns X, AB and AF based on the codes in Y, AC and AG; then in column T add only the B hours found in columns X, AB and F based on the codes in Y, AC and AG. SUMIF is not playing well with multiple cells, it returns an error of too many arguments. And when I try to enclose multiple cells in ( ) the #VALUE! error appears. Of course the calculations in P, R and T will be the same syntax with a variation of the cells used. I'd appreciate an example for either column P, R or T. Thank you so much. |
Tags |
sumif |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Borders on merged cells also appearing on unwanted adjacent cells | MrsC | Word Tables | 2 | 08-19-2019 09:14 AM |
Need help with an IF formula, which is based on adjacent cells being in the Top 30% of a range | FarStar | Excel | 17 | 07-26-2017 07:55 AM |
Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
Adding adjacent cells and having the sum appear in two separate places | Seamus Sean | Excel | 4 | 12-11-2016 10:34 PM |
Using alternating borders in adjacent cells | jrevard | Word | 0 | 10-15-2015 09:07 AM |