Excel - How to sum values for specific days
How can I sum all the OT(hr) value only for specific day? Requirement: I need to sum all the OT(hr) for one person for Sunday only. One person means one row in the table.
I tried this few code but it doesn't work : =sumif(WEEKDAY(1,1),O8:AD8) or =SUMIF(O8:AD8,TEXT(O6:AD6,"dddd")="Sunday")
Thank you so much
Solution
In my example, I don't use merged cells. I wouldn't recommend having merged cells for the date. Date must be above the OT (hr). And the Ot (hr) you also need to put into the formula. This formula was working for me:
=SUM((WEEKDAY(O2:AD2;1)=1)*(O3:AD3="OT (hr)")*(O4:AD4))
- What is the equivalent of the "Days" function or number of days between 2 dates in excel 2007?
- Need help aligning a table to a column based on similar values in one table field
- Index rows and columns unexpected results
- Automatic numbering in Excel with hierarchy
- How to do a row-wise sum in an array formula in Excel?
- Transform datatable from column-based to row-based
- Combine most recent 5 records into one cell in Excel
- Matching multiple number rows and check corresponding dates within 90 days
- Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
- How can I use countif to return only a count if sum is > 0 but only count it once
- excel No of hours in a shift
- How do transform a "matrix"-table to one line for each entry in excel
- How to fill fast for integer number calculation?
- Find Corresponding Value Based on Today's Date Falling Between Week-Ending Dates in Excel
- Date format issue when I try to find the first occurrence of names with associated dates
- Excel - How can we replace multiple characters or whole words in a cell using LAMBDA()
- Nested if statements in EXCEL dependent on first condition
- List only workdays in given dynamic month
- INDIRECT array to refer to a table column not working with array formulas
- Putting a concatenate inside of a count if
- Excel: how to search by two rows and one column
- Excel - Check existing digit count, if <10 then add prefix "100" to make it 10 digit
- Custom Excel formula for length restriction of substring within a string in a cell
- COUNTIFS across multiple columns with multiple criteria
- Occurrence by month using Excel Functions
- Strange behavior in Excel when counting Work Hours and Work Super Hours
- Need help fixing my excel formula so it doesn't show #VALUE! error in end result
- Can I guarantee the Image Formula Function is finished before printing the result?
- Excel filter data in date intervals excluding all 0 values
- Count cells with two conditions