T
trant
OK Thanks to the help of members of this board I learned to use SUMIF to sum
the values of a column based on a condition... but what if I have multiple
conditions?
Here's my complicated scenario...
I have columns B, G and H represented here.
I am trying to sum up all the values of columns G & H based on certain
conditions.
=SUMIF(B6:B9999,"<>F",G6:G9999)+SUMIF(G6:G9999,"0",H6:H9999)
First, ignore the entire column if value of B is "F", so that's my first
SUMIF.
Then my second SUMIF is supposed to be if the value of G is 0, then add the
value of H to the sum (otherwise always ignore H)
But it fails when the value of column B is "F" AND the value of G is 0,
because then it includes the value of H thanks to my second SUMIF.
How do I either ignore the second SUMIF if the condition of my first SUMIF
is false or how to I have multiple conditions in my second SUMIF to basically
say if G is 0 AND B <> "F" ?
the values of a column based on a condition... but what if I have multiple
conditions?
Here's my complicated scenario...
I have columns B, G and H represented here.
I am trying to sum up all the values of columns G & H based on certain
conditions.
=SUMIF(B6:B9999,"<>F",G6:G9999)+SUMIF(G6:G9999,"0",H6:H9999)
First, ignore the entire column if value of B is "F", so that's my first
SUMIF.
Then my second SUMIF is supposed to be if the value of G is 0, then add the
value of H to the sum (otherwise always ignore H)
But it fails when the value of column B is "F" AND the value of G is 0,
because then it includes the value of H thanks to my second SUMIF.
How do I either ignore the second SUMIF if the condition of my first SUMIF
is false or how to I have multiple conditions in my second SUMIF to basically
say if G is 0 AND B <> "F" ?