Forum Discussion

Lualolga's avatar
Lualolga
Copper Contributor
Jun 12, 2023
Solved

Calculate outstanding balance

Hello!, I wonder if anyone could help please. Imagine a regular Budget type of spreadsheet Column A we have titles Column B we have figures, B32 is the Sum of the figures e.g. =Sum(B2:b30) Column...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 12, 2023

    Lualolga 

    =B32-SUMIF(C2:C30,"Y",B2:B30)

     

    This works in my sample sheet in cell C32.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 12, 2023

Lualolga 

=B32-SUMIF(C2:C30,"Y",B2:B30)

 

This works in my sample sheet in cell C32.

  • Lualolga's avatar
    Lualolga
    Copper Contributor
    Jun 12, 2023
    Thank you it has worked perfectly 🙂
  • Lualolga's avatar
    Lualolga
    Copper Contributor
    Jun 12, 2023
    Perfect thank you

Resources