Forum Discussion

MassiveSpreadsheetNoob's avatar
MassiveSpreadsheetNoob
Copper Contributor
Dec 14, 2024
Solved

Solving nested if sum calculator for checkbox tasks

Hello !

Can anyone solve the error in this equation ? I can't see it...

Would greatly appreciate any questions or solutions.

=sum((IF(G2=TRUE, =SUM(D2/1000*9),0))+(IF(H2=TRUE, 1, 0))+(IF(I2=TRUE, 1, 0))+(IF(J2=TRUE, 1, 0))+(IF(K2=TRUE, 1, 0))+(IF(L2=TRUE, 1, 0)) )

 

admin
excel
Formulas and Functions
Office Scripts
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 16, 2024

    Perhaps you mean

    =SUM(
  IF( G2=TRUE, SUM(D2/1000*9),0) +
  IF( H2=TRUE, 1, 0)  +
  IF( I2=TRUE, 1, 0)  +
  IF( J2=TRUE, 1, 0)  +
  IF( K2=TRUE, 1, 0) +
  IF( L2=TRUE, 1, 0)
)

    or if to simplify

    = IF( G2, D2/1000*9,0) + H2 + I2 + J2 + K2 + L2

    or

    = IF( G2, D2/1000*9,0) + SUM( 1*H2:L2 )

     

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 16, 2024

    Perhaps you mean

    =SUM(
  IF( G2=TRUE, SUM(D2/1000*9),0) +
  IF( H2=TRUE, 1, 0)  +
  IF( I2=TRUE, 1, 0)  +
  IF( J2=TRUE, 1, 0)  +
  IF( K2=TRUE, 1, 0) +
  IF( L2=TRUE, 1, 0)
)

    or if to simplify

    = IF( G2, D2/1000*9,0) + H2 + I2 + J2 + K2 + L2

    or

    = IF( G2, D2/1000*9,0) + SUM( 1*H2:L2 )

     

Resources