RobertBC
09-19-2006, 11:04 AM
good day!
I had this problem of getting the total of for a sales..
I want to sum all the values on a single column with a condition,
and that condition is refer to another column or value of a cell in a column..
examples..
sum if <Range of Cells> equal to "cash"
sum if <Range of Cells> equal to "check"
sum if <Range of Cells> equal to "card"
sum if <Range of Cells> not equal to "cash"
sum if <Range of Cells> not equal to "check"
sum if <Range of Cells> not equal to "card"
attached is my example file..
thanks :bow:
I had this problem of getting the total of for a sales..
I want to sum all the values on a single column with a condition,
and that condition is refer to another column or value of a cell in a column..
examples..
sum if <Range of Cells> equal to "cash"
sum if <Range of Cells> equal to "check"
sum if <Range of Cells> equal to "card"
sum if <Range of Cells> not equal to "cash"
sum if <Range of Cells> not equal to "check"
sum if <Range of Cells> not equal to "card"
attached is my example file..
thanks :bow: