G
Gary Thomson
I want to do a SUMIF that will add amounts from either
column C, D or E based on the following criteria:
For each cell in the range F2:F200, if there is a "y" in
that cell, then add the corresponding amount from column C
(i.e. if there is a "y" in cell F5, then the SUMIF will
pick up the amount in cell C5, and so on..)
For each cell in the range F2:F200, if there is no "y" in
that cell, the SUMIF (or whatever function can be used)
would look at each cell in the range G2:G200. For each
cell in the range G2:G200 with an "x" in it, look in the
corresponding cell in the range H2:H200, and if the number
in this cell is >5, then add the corresponding amount in
Column E; if the number in this cell is <=5, then add the
corresponding amount in Column D.
(i.e. if there is no "y" in cell F8, then look in cell G8,
and if there is an "x" in this cell then look in cell H8,
and if the number is greater than 5, the SUMIF would pick
up the amount in cell E8; alternatively if the number in
cell H8 was <=5, then the SUMIF would pick up the amount
in cell D8).
Finally (to cover all possibilities), for each cell in the
range F2:F200, if there is no "y" in that cell, the SUMIF
would look at each cell in the range G2:G200, and for each
cell with no "x" in this range, the SUMIF would pick up
the amount in the corresponding cell in column D.
I know I could do a lengthy IF statement for each cell row
from 2 to 200, but my spreadsheet is already pushing the
limits of the memory in my computer and I'm looking for
ways to simplify this.
Is there a way to do this using multiple SUMIF statements
column C, D or E based on the following criteria:
For each cell in the range F2:F200, if there is a "y" in
that cell, then add the corresponding amount from column C
(i.e. if there is a "y" in cell F5, then the SUMIF will
pick up the amount in cell C5, and so on..)
For each cell in the range F2:F200, if there is no "y" in
that cell, the SUMIF (or whatever function can be used)
would look at each cell in the range G2:G200. For each
cell in the range G2:G200 with an "x" in it, look in the
corresponding cell in the range H2:H200, and if the number
in this cell is >5, then add the corresponding amount in
Column E; if the number in this cell is <=5, then add the
corresponding amount in Column D.
(i.e. if there is no "y" in cell F8, then look in cell G8,
and if there is an "x" in this cell then look in cell H8,
and if the number is greater than 5, the SUMIF would pick
up the amount in cell E8; alternatively if the number in
cell H8 was <=5, then the SUMIF would pick up the amount
in cell D8).
Finally (to cover all possibilities), for each cell in the
range F2:F200, if there is no "y" in that cell, the SUMIF
would look at each cell in the range G2:G200, and for each
cell with no "x" in this range, the SUMIF would pick up
the amount in the corresponding cell in column D.
I know I could do a lengthy IF statement for each cell row
from 2 to 200, but my spreadsheet is already pushing the
limits of the memory in my computer and I'm looking for
ways to simplify this.
Is there a way to do this using multiple SUMIF statements
200)