English 中文(简体)
采用多种标准为多个独立行提供的经费援助
原标题:Assistance with sum for multiple separate rows using multiple criteria please

我正试图拿出办法,把客户的时间总结为横向表格,包括多个客户和雇员。

客户可以变换成一种非常理想的需要,即使用工作标准的人和客户通过桌旁搜寻和增加时间。

http://www.ohchr.org。

“table

掌握了我对冲绳和总产线的了解,但没有uck。 例365。

赞赏任何帮助——感谢!

最佳回答

Pls.在C10中尝试这一办法,并复制。

=LET(rng,C$2:I$5,client1,B10,SUM(IF(TOROW(CHOOSEROWS)(rng,SE RequestNCE(1,ROWS(rng)/2,1,2)))=客户1,TOROW(CHOOSERS(rng,SE RequestNCE (1,ROWS(rng)/2,2,2)),0))

Adjust rng to the actual amount of theuser/Has work data range. client1 to the first name cell of the result table.

问题回答

一种类似于@Black cats的解决办法,但可以读取:

公式假设奇数的行数为时数,甚至指数的行数为客户,每小时的行数都有客户。

=LET(
    range, 2:5,
    hourRows, TOCOL(FILTER(range, MOD(ROW(range), 2))),
    clientRows, TOCOL(FILTER(range, 1 - MOD(ROW(range), 2))),
    SUM(FILTER(hourRows, clientRows = "Alpha"))
)

为节约业绩,你总是可以限制范围,例如





相关问题
import of excel in SQL imports NULL lines

I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

Excel date to Unix timestamp

Does anyone know how to convert an Excel date to a correct Unix timestamp?

C# GemBox Excel Import Error

I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...