sum array

<tbody> Item no. Catagory Date Amt A T01 1/1/2017 10 A T01 1/5/2017 15 A T01 5/5/2018 20 B T01 1/1/2017 15 B T01 1/1/2017 15 B T02 1/1/2017 15 ..... </tbody> I'm trying to determine the item no. under catagory "T01", within a period from 1/1/2017 to 1/31/2017...

Hi I'm trying to find a formula that where row# in Col C =1 AND same row Col A=Q1 I sum the cells in Col B from those rows <tbody> Col A Col B Col C Row A Q1 5 1 Row B Q1 2 Row C Q2 1 1 Row D Q1 6 1 Row E Q4 3 </tbody> In my spreadsheet I have to repeat...

Hello, I am looking for a way to increase the cell row number of a SUM function by 4 as I copy the formula. The SUM is across two sheets. The formula in my first cell (G7, on a sheet called '60 min') is: =SUM('15 min'!G7:G10) I want the formula to copy into G8 on the '60 min' sheet as...

How can I do a sumifs field with multiple criterias in a column? Example: - the values are in row c - the first lookup column is in row b. The lookup field is months. - the second lookup column is in row a. The lookup field is category type (various expense type) Desired Output: I want...

I have an array which is produced using the following: {=(COUNT(OFFSET($I$2:$I$6,,(E9-(A15:A17)))))} When I select 3 cells and enter this formula it produces the desired values. However, if I try to SUM or SUMPRODUCT this formula it returns zero. Is this possible to SUM or SUMPRODUCT or is...

Hello, I'm trying to generate a lookup that would return a value in a column based on several criteria and the SUM MAX of two figures. Been using INDEX(SUMPRODUCT()) for all of my lookups up till now, so thinking it may be just a matter of appropriately nesting MAX, SUM, SUMPRODUCT, and INDEX...

Hello all, I have a worksheet that lists the value of various commodities in a single cell. e.g. in Cell A1 3 Piles, 5 Masts, 3 Beams There are many such cells on a worksheet and I would like to calculate totals for each commodity. To do this my thinking is to find the commodity start...

I have been going round in circles with this for a while now.... I have a table as follows; A1 ProjectDate ClientName ProjectDuration A2 22-Sep-15 Client 1 1:56:20 A3 22-Sep-15 Client 2 8:33:21 A4 22-Sep-15 Client 3 2:45:55 A5 22-Sep-15 Client 4 16:22:01 A6 22-Sep-15 Client 5 1:00:00 A7...