19 мар. 2017 г. · I need to use FILTER() to sum some cells only if two conditions are TRUE. This code works for one condition =sum(filter(H4:H, regexmatch(G4:G, "TextA"))

3 мая 2013 г. · I would like to add up the time where the column to the right is "Yes". I am using the following to add up all time (3:00): =SUM(A1:A5)

14 окт. 2019 г. · When I filter on a company I want the total to display the sum of the whole of B column. Since I am very new to spreadsheets I was hoping someone could help me.

7 нояб. 2022 г. · I want to sum up all the matching categories from Table 1 with the result in each row of table 2. Table 1 (list of transactions)

11 янв. 2019 г. · I'm already running some SUMIF functions to total a column if another column matches a criteria, but I now need to add in another criterion.

2 сент. 2021 г. · I have a sheet with data like this: AB x 1 y 2 z 3 x 4 I can sum the values with =query(A:B, "select A, sum(B) group by A") How can I then filter this result?

22 мар. 2022 г. · The filter must be based on attendance, not on its sum. So it will simply be: =attendance > 0. FILTER.

2 авг. 2012 г. · The date range formula I've been using is: =sumif($A:$A,"<="&D$5,$C:$C)-sumif($A:$A,"<"&D$4,$C:$C) Which works

26 февр. 2021 г. · The most obvious difference between the two formula is that you sum the filter for "Checkings" but you don't sum the filter for "CC-Chase".

17 мар. 2021 г. · I'm trying to sum all data in column E, where the row has a particular value in column D (in this instance '-2'). I have tried the below formula with no joy.