T

#### trant

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" ?