LinkBack URL
About LinkBacks
Hi, Seems to be a problem with blank cells, add one more criteria, it will work
Formula:
=SUMPRODUCT(--('Tab1'!$C$2:$C$510<>""),--(WEEKDAY('Tab1'!$C$2:$C$510,11)=$A71))
Hi, Seems to be a problem with blank cells, add one more criteria, it will work
Formula:=SUMPRODUCT(--('Tab1'!$C$2:$C$510<>""),--(WEEKDAY('Tab1'!$C$2:$C$510,11)=$A71))
☚ Click ★ just below left if it helps, Boo?ath?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks