Forum Discussion
Trying to use IF formula
Hi Guys! I need to calculate total hours worked on a Saturday. Let me explain: In column F I have total hours worked for the day & in column B I have my calendar days (e.g. Monday, Sunday ....). N...
Mellan3
Hello! I am not sure why you would need the formula for that in Column G. If you can share your sample data, I can help better. However, I created this dummy data not sure if that's how yours look like and if so, the formula you need is the SUMIF formula. Please find the attached excel and let me know if it is what you like; I made the SUMIF formula dynamic so that if you need the sum of hours for any other day, select the data under the drop-down in cell G2.