I have explain the problem in file attached.
Please see the issue, thank you in advance.
Teachers Attendance CA (March 2014).xlsx
I have explain the problem in file attached.
Please see the issue, thank you in advance.
Teachers Attendance CA (March 2014).xlsx
Hi,
It's password-protected.
Regards
oh sorry password is "Acca"
Sorry. Now my machine warns me against opening that file, so I'll have to pass.
Regards
You are missing a parenthesis
Try
=SUMPRODUCT((MONTH('Daily Classes'!$C$6:$C$5050)=MONTH(H$3))*('Daily Classes'!$E$6:$E$5050=$B4)*('Daily Classes'!$F$6:$F$5050=$C4)*('Daily Classes'!$H$6:$H$5050=$F4),'Daily Classes'!$O$6:$O$5050)
format as [hh]:mm
Life's a spreadsheet, Excel!
Say thanks, Click *
I have attached new file without password.
Because your time formulas can return "" you may not multiply in the formula:
=SUMPRODUCT((MONTH('Daily Classes'!$C$6:$C$5050)=MONTH(H$3))*('Daily Classes'!$E$6:$E$5050=$B4)*('Daily Classes'!$F$6:$F$5050=$C4)*('Daily Classes'!$H$6:$H$5050=$F4),'Daily Classes'!$O$6:$O$5050)
thank u....Ace
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks