Skip to main content
Web Applications

Return to Question

Formatting
Link
edit approved Sep 30, 2019 at 15:49
DaImTo
edit approved Sep 30, 2019 at 15:49
DaImTo
  • 225
  • 2
  • 13

PROBLEMS WITH Problems with SUMIFS FUNCTION WITH GOOGLE SHEETSfunction

added 27 characters in body
Source Link
marikamitsos
marikamitsos
  • 13.1k
  • 4
  • 34
  • 59

I don't understand why SUMIFS function works with some columns in the same worksheets and for others it doesn't. This is my formula:

=SUMIFS(EURO;AGENZIE;"ABN";MESI1;"01")

where EUROEURO, AGENZIEAGENZIE, ABNABN AND MESI1MESI1 are the name of some columns in the same sheet. The formula is needed to add the values in the EUROEURO column when the condition in others columns is that they are equal to ABN ABN (AGENZIEAGENZIE) and month is January (MESI1=01MESI1=01). Column AGENZIEAGENZIE had other values, and when they are used instead of ABNABN the formula seems to work. My

My question is: how the heck is it possible that the same formula works depending on the value I use as condition? I
I don't get any error, only the result is zero when it should be <>0. Thanks
Thanks for helphelping me solve this problem

I don't understand why SUMIFS function works with some columns in the same worksheets and for others it doesn't. This is my formula:

=SUMIFS(EURO;AGENZIE;"ABN";MESI1;"01")

where EURO, AGENZIE, ABN AND MESI1 are the name of some columns in the same sheet. The formula is needed to add the values in the EURO column when the condition in others columns is that they are equal to ABN (AGENZIE) and month is January (MESI1=01). Column AGENZIE had other values, and when they are used instead of ABN the formula seems to work. My question is: how the heck is possible that the same formula works depending on the value I use as condition? I don't get any error, only the result is zero when it should be <>0. Thanks for help me solve this problem

I don't understand why SUMIFS function works with some columns in the same worksheets and for others it doesn't. This is my formula:

=SUMIFS(EURO;AGENZIE;"ABN";MESI1;"01")

where EURO, AGENZIE, ABN AND MESI1 are the name of some columns in the same sheet. The formula is needed to add the values in the EURO column when the condition in others columns is that they are equal to ABN (AGENZIE) and month is January (MESI1=01). Column AGENZIE had other values, and when they are used instead of ABN the formula seems to work.

My question is: how is it possible that the same formula works depending on the value I use as condition?
I don't get any error, only the result is zero when it should be <>0.
Thanks for helping me solve this problem

Source Link
Nico Rossi
Nico Rossi
  • 1
  • 1

PROBLEMS WITH SUMIFS FUNCTION WITH GOOGLE SHEETS

I don't understand why SUMIFS function works with some columns in the same worksheets and for others it doesn't. This is my formula:

=SUMIFS(EURO;AGENZIE;"ABN";MESI1;"01")

where EURO, AGENZIE, ABN AND MESI1 are the name of some columns in the same sheet. The formula is needed to add the values in the EURO column when the condition in others columns is that they are equal to ABN (AGENZIE) and month is January (MESI1=01). Column AGENZIE had other values, and when they are used instead of ABN the formula seems to work. My question is: how the heck is possible that the same formula works depending on the value I use as condition? I don't get any error, only the result is zero when it should be <>0. Thanks for help me solve this problem