View original (French)

Sum if greater or less

Solved
Marfi67 Posted messages 21 Status Member -  
tontong Posted messages 2575 Registration date   Status Member Last intervention   -
Hello everyone,
I would like to ask for your help regarding a table I need to create.

I have a table with weeks in columns and equipment in rows. This table indicates the number of interventions per week and per piece of equipment.

I have a second piece of data which is the maintenance week of a piece of equipment.

I would like to know the number of interventions per piece of equipment before and after maintenance.

Equipment x was maintained in week Y and experienced z failures before maintenance in week Y and W after.

I was considering using the SUMIF formula, but it wasn't working.

I don't know how to attach a screenshot; otherwise, I would have done it.

Thank you for your help.

4 answers

  1.
    tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    Hello,
    Did you correctly follow the syntax of SUMIF?
    We assume the week numbers in A2:A53, the number of equipment failures in E2:E53, and the maintenance week in E60= 32. The week numbers and the number of failures are indeed numbers, not text!
    Before: = SUMIF(A2:A53,"<32",E2:E53)
    Or = SUMIF(A2:A53,"<"&E60,E2:E53)
    For the "after" sum, the transposition is easy ;-)
    0