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...
If column B contains Monday etc. as text, you can use a SUMIF formula:
=SUMIF(B2:B100, "Saturday", F2:F100)
Adjust the ranges if needed.
If column B contains date values formatted as dddd to display the day of the week, you'll need a different formula, for example
=SUMPRODUCT(--(WEEKDAY(B2:B100)=1),F2:F100)