SkatePropertyTofuEquities
New Member
- Joined
- Jan 24, 2018
- Messages
- 5
Hey all,
I need excel to try to find data meeting 2 criteria and if the data does not meet them, to default to the amount in sheet1!C2
I currently have this working perfectly:
=SUMIFS(Journal!$B$4:$B$1000,Journal!$A$4:$A$1000,Cashflow!B8,Journal!$C$4:$C$1000,">="&Cashflow!C$6-1,Journal!$C$4:$C$1000,"<="&Cashflow!D$6)
Which says: sumrange (Journal!b4:b1000), if A is found in CriteriaRange1, and B is above (a date)-1 but below (another date) then return the corresponding figure in the sumrange. But it returns a value of "0" if criteria not met - as i said, I need it to default to the value provided in sheet1!C2
Thank you!
SPTE
I need excel to try to find data meeting 2 criteria and if the data does not meet them, to default to the amount in sheet1!C2
I currently have this working perfectly:
=SUMIFS(Journal!$B$4:$B$1000,Journal!$A$4:$A$1000,Cashflow!B8,Journal!$C$4:$C$1000,">="&Cashflow!C$6-1,Journal!$C$4:$C$1000,"<="&Cashflow!D$6)
Which says: sumrange (Journal!b4:b1000), if A is found in CriteriaRange1, and B is above (a date)-1 but below (another date) then return the corresponding figure in the sumrange. But it returns a value of "0" if criteria not met - as i said, I need it to default to the value provided in sheet1!C2
Thank you!
SPTE