Forum Discussion
Formulas
Good morning, Everyone, I am currently trying to figure out formula or function for my employee vacation tracker spreadsheet. I am not sure if it is possible, but what I would like to happen is w...
=I2-SUMPRODUCT(($B$1:$E$1=H2)*($B$2:$E$28="V")*8)This formula could be a solution. The results can be displayed on another worksheet as well.
OliverScheurich How would I make the formula account for each monthly tab below? I have attached photos of my sheet. The employee's tab is where the total hours are located.
=B2-SUMPRODUCT(($A2=january!$A$2:$A$23)*(january!$B$2:$AF$23="V"))*8-SUMPRODUCT(($A2=february!$A$2:$A$23)*(february!$B$2:$AC$23="V"))*8You can try a formula like this. For months march to december you can add a SUMPRODUCT expression to the formula accordingly. However there should be a solution with a shorter formula.
- I appreciate your help on this. What if I wanted to include "P" and "S" as full 8 hours as well. And the HD to equal 4 hours?
