英文:
Display all data from a certain range and sum the value of their right cell
问题
I'm not sure how to go about this since I'm still a newbie at Excel and I only know how to COUNTIF in static lists. My problems are:
- A8 and below - How to dynamically display the Tasks from a dynamic list (B3-B5, D3-D5, F3-F5 and so on and so forth)
- B8 and below - How do I get the sum of Hours of each Task items?
英文:
I'm not sure how to go about this since I'm still newbie at Excel and I only know how to COUNTIF in static lists. My problems are:
- A8 and below - How to dynamically display the Tasks from a dynamic list (B3-B5, D3-D5, F3-F5 and so on and so forth)
- B8 and below - How do I get the sum of Hours of each Task items?
答案1
得分: 3
=假设范围为B2:K4：
=LET(
ζ, B2:K4,
ξ, WRAPROWS(TOCOL(ζ), 2),
γ, TAKE(ξ, , 1),
δ, SORT(UNIQUE(γ)),
HSTACK(δ, BYROW(δ, LAMBDA(ε, SUM((γ = ε) * TAKE(ξ, , -1))))))
(Note: I've provided the translated code portion without additional content as requested.)
英文:
Assuming a range of B2:K4:
=LET(
ζ, B2:K4,
ξ, WRAPROWS(TOCOL(ζ), 2),
γ, TAKE(ξ, , 1),
δ, SORT(UNIQUE(γ)),
HSTACK(δ, BYROW(δ, LAMBDA(ε, SUM((γ = ε) * TAKE(ξ, , -1)))))
)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论