-3
My idea here would be to put the CA1 QTD at the time of 14:49 in column B 2x2, and so on, organizing all the schedules.
1 answer
0
It is possible to perform this action with the formula =somases, it returns the sum of an interval/column based on conditions (Time and Type, in this case). It would look like this in cell B2:
=SOMASES($P:$P;$N:$N;$A2;$O:$O;B$1)
The key is to correctly use the relative and absolute reference, which is the dollar ($) in the formula, see.
In the code above, the columns P, N and O are defined as absolute, that is, they are fixed by inserting the formula in any column that will have the result (range of B2:I34, for example)). We use the $ in front of the whole range.
The references of criteria, however, mix relative and absolute. A $A2 leaves the absolute column (fixed) and the relative row (variable), while the B$1 does the opposite, leaves the relative column and the absolute row. We use $ only in the specific part.
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
Hello Celso, what have you tried to do? ask the question the formula you have used and what is the difficulty or failure
– Ricardo Pontual