Hi guys, i have been struggling for a while now on how to make numbers add certain values based on an expression from other item in the same row.
So, this is my table. which is called "Base Pequeña":
and I want to get an average of the values on column "H" based on the place listed on column "A". this is the function I've tried with no success:
Assume "HUEHUETENANGO" is a value found in column "A"
Thanks in advance for your help.
MacBook Pro
you should use the function:
SUMIF()
you can get help on any function by typing the "=" (equal sign) in a cell, then look at the right of the window to the function browser. type the first letters to filter the list.
change the formula you are trying to:
=sumif(Base Pequeña::Table 1:H, "HUEHUETENANGO", Base Pequeña::Table 1:H)
TEST VALUES MATCH VALUE SUM VALUES
this will sum that values in column H if the value in column A matches "HUEHUETENANGO" of the same row
Appreciate your help, this worked. Do you know what could be done if I needed to average column "H" if column "A = GUATEMALA" and "D = BUS"?
=sumif(Base Pequeña::Table 1:H, "HUEHUETENANGO", Base Pequeña::Table 1:H)/countif(Base Pequeña::Table 1:H, "HUEHUETENANGO")
Numbers: Iterate through tables
