I'm trying to do something on Excel which isn't working. I've managed 2 separate formulas that work separately but can't figure out how to combine them. Separate formulas are:
=IF(K3>I3,"","Yes")
and
=SUM(COUNTIF(D3,{"Opportunity Qualified","KDM Needs Defined","Proposition Developed","Terms & Stock OK","VP Pitched to KDM","Reshaped & Repitched","Won Pending Invoice"})\*{1,2,3,4,5,6,7})
I want to replace the values K3
and I3
with the =(SUM(COUNTIF....
value but am getting an error message when I do this:
=IF((SUM(COUNTIF(K4,{"Opportunity Qualified","KDM Needs Defined","Proposition Developed","Terms & Stock OK","VP Pitched to KDM","Reshaped & Repitched","Won Pending Invoice"})\*{1,2,3,4,5,6,7}))>(SUM(COUNTIF(I4,{"Opportunity Qualified","KDM Needs Defined","Proposition Developed","Terms & Stock OK","VP Pitched to KDM","Reshaped & Repitched","Won Pending Invoice"})\*{1,2,3,4,5,6,7}),"","Yes"))
Any ideas? I'm a bit of an Excel novice but this formula looks overly complicated!