How to do conditional sum in Excel?

Very Easy way to add up in Excel based on a certain condition.
If your task requires adding only those cells that meet a certain condition or a few conditions, you can use the SUMIF or SUMIFS function, respectively.

For example, the following SUMIF formula adds only those amounts in column B that have "Completed" status in column C:

=SUMIF(C:C,"completed",B:B )

[Perrove]

cant hear nothing bro, you need to fix the sound