Forum Discussion

juan jimenez's avatar
juan jimenez
Iron Contributor
Nov 28, 2021

EXCEL SUM.IF....

hi! I have been trying to make a chat en the attaced excel that is not working. The problen is in "T1 Bilan" page. can someone tell me why data coming from page "journal" is not taking into consid...
Excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 29, 2021

    juan jimenez 

    I didn't check entire formula, but in column G you have partly texts partly numbers. It shall be something one, depends on criteria used

OliverScheurich's avatar
OliverScheurich
Gold Contributor

juan jimenez 

=+F5+SUMIFS(journal!$J:$J,journal!$G:$G,$D5,journal!$F:$F,$B$2,journal!$E:$E,'T1 Bilan'!G$3)-SUMIFS(journal!$K:$K,journal!$G:$G,$D5,journal!$F:$F,$B$2,journal!$E:$E,'T1 Bilan'!G$3)

 

I guess journal!$E:$E,'T1 Bilan'!G$3 has to be entered instead of journal!E:E,'T1 Bilan'!G3.

juan jimenez's avatar
juan jimenez
Iron Contributor
Nov 29, 2021

OliverScheurich 

Thank you, you were right about that missing "$". however, the following years the sum.if formula still does not work...

 

Any suggestions?

 

Thank you, Juan

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Nov 29, 2021

    juan jimenez 

    In my spreadsheet the numbers for the following years are calculated by sumifs formula as intended.

     

    However when i opened your spreadsheet there was an error message that a named range was removed because it couldn't be read. Maybe this causes different results in your and my spreadsheet.

Share

Resources