Create a formula using if, and, or or.
"joanaww" wrote:
I just tried this, but maybe I did something wrong. I'm actually using this statement as a condition for a sumif statement, where a column contains several dates, and either of two of them might qualify as criteria for a given time period. I can do this if I have only one month I'm searching for. Actually, I'm trying to sum up the amounts paid, which can come in any month, by time period (corresponding to meeting dates). (I'm having trouble using this form, as I don't know where I'm supposed to type my reply - there is no blinking cursor.)
"Pete" wrote:
I think this last example should be:
=If(OR(b1=3,c15),"One or both Conditions exist","Neither Condition
exists")
Pete
I just tried this, but maybe I did something wrong. I'm actually using this statement as a condition for a sumif statement, where a column contains several dates, and either of two of them might qualify as criteria for a given time period. I can do this if I have only one month I'm searching for. Actually, I'm trying to sum up the amounts paid, which can come in any month, by time period (corresponding to meeting dates).
|