G
Guest
I'd like to get the sum of a range of cells when two conditions from two
different columns are met.
i.e: if w3:w28=2, and X3:w28=56000, then sum of those cells that are meeting
the two previous conditions.
I have this formula: =IF(AND($W$3:$W$28=2,$X$3:$X$28=56000),SUM(R3:R28))
which gives me the sum of all the cells from r3 to r28. I'd just want the sum
of the cell that meet the two previous conditions. Does this make sense? can
someone help?
different columns are met.
i.e: if w3:w28=2, and X3:w28=56000, then sum of those cells that are meeting
the two previous conditions.
I have this formula: =IF(AND($W$3:$W$28=2,$X$3:$X$28=56000),SUM(R3:R28))
which gives me the sum of all the cells from r3 to r28. I'd just want the sum
of the cell that meet the two previous conditions. Does this make sense? can
someone help?