Forum Discussion

steele86's avatar
steele86
Copper Contributor
Sep 13, 2020

If and Sum Nested formula

This is what I have =if(b9:F9=0,"",B9:F9). Obviously it's not working lol. I'm having trouble with the false. According to my assignment, it's supposed to display the sum if it is false.   here is ...
excel
Oldrockz's avatar
Oldrockz
Copper Contributor
Oct 16, 2020

HansVogelaar the question wants us to create a nested formula containing IF and SUM, so we are asking if how to create a nested formula containing SUM and IF functions, or if we could use SUMIF. we need the function to check and see if the sum of hours worked during 1 week is 

=0 if yes then we need it to display nothing, otherwise we need the cell to display hours of time worked 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 16, 2020

Oldrockz Try this:

=IF(SUM(B9:F9)=0,"",SUM(B9:F9))

 

  • OVO22's avatar
    OVO22
    Copper Contributor
    Oct 29, 2022
    Thank u
  • DEOL48's avatar
    DEOL48
    Copper Contributor
    Jun 05, 2022

     I have a above formula in column but I need a Sum of this column ang SUM formula is showing 00:00

    Riny_van_Eekelen 

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jun 05, 2022

      DEOL48 

      The values in column F are left-aligned. That suggests they might be text values.

      Try the following:

      • Select column F.
      • Set the number format to a time format,
      • On the Data tab of the ribbon, click Text to Columns.
      • Click Finish.

      Does that make a difference?

  • JBailey992's avatar
    JBailey992
    Copper Contributor
    Mar 19, 2022
    Thank you! I also am working on this assignment for Excel and could not figure out this formula either. I greatly appreciate your help!

Resources