Sum if greater or less
Solved
Marfi67
Posted messages
21
Status
Membre
-
tontong Posted messages 2575 Registration date Status Membre Last intervention -
tontong Posted messages 2575 Registration date Status Membre 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.
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 réponses
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 ;-)
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 ;-)
here is a screenshot, it's more explicit
https://www.casimages.com/i/130816055425869895.png.html
best regards