在多列表中有条件地对特定列进行总和 [英] Conditionally sum specific columns in multiple column table

问题描述

我有一个时间表，显示一年中的每一天。这些列以月份名称开头， h （小时）。如果我用标签标记一天，我会在其旁边的 h 列上添加一个数字。每当找到相应的标签时，应该总结出这些数字。

所以公式（不是查询！）应该在整个时间表上寻找一个特定的标签，并将一个单元格旁边的所有数字加起来。

我已经尝试了几个解决方案，但我猜想只是不明白数组公式的机制来实现一个解决方案，甚至SUMIFS函数也没有让我在任何地方。

解决方案

  = SUMIF（B4：Y34，WM，C4：Z34）
  

适用于我不知道为什么 sumifs 不适合你，但是你没有说出你的问题是什么。

I have a timetable that shows every day of the year. The columns are headed with month names and h (for hour). If I mark a day with a label I put a number on the h column right next to it. These numbers should be summed up whenever the appropriate label is found.

Example of my timetable

So the formula (not query!) should look for a specific label on the whole timetable and sum all numbers right next to it in one cell.

I've tried several solutions but I guess I just don't understand the mechanism of array formulae to achieve a solution and even the SUMIFS function doesn't get me anywhere.

解决方案

=SUMIF(B4:Y34,"WM",C4:Z34)  

works for me. Don't know why sumifs didn't for you but then you haven't said what your problem was with it.

这篇关于在多列表中有条件地对特定列进行总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！