Excel

2024-05-16豪~豪阅读(879)评论(0)赞(0)

=SUMPRODUCT((X3=1)*(AC3=1)*(AH3=1)*(AO3))

2024-05-11豪~豪阅读(727)评论(0)赞(0)

=CONCATENATE(RIGHT(YEAR(TODAY()),2),IF(LEN(WEEKNUM(TODAY(),2))=1,"0",""),WEEKNUM(TODAY(),2))