My formula works when I use only one criteria but when I include an and with a second criteria it doesnt work - any idea why?
This one works:
=MIN(IF('Citi - Sheet1'!$C$2:$C$10091=B107,'Citi - Sheet1'!$E$2:$E$10091))
and this one works
=MIN(IF('Citi - Sheet1'!$D$2:$D$10091=45,'Citi - Sheet1'!$E$2:$E$10091))
but when I combine these 2 criteria I get 0 - which is incorrect
=MIN(IF(AND('Citi - Sheet1'!$C$2:$C$10091=B107,'Citi - Sheet1'!$D$2:$D$10091=45),'Citi - Sheet1'!$E$2:$E$10091))
Thanks,
Yosef
This one works:
=MIN(IF('Citi - Sheet1'!$C$2:$C$10091=B107,'Citi - Sheet1'!$E$2:$E$10091))
and this one works
=MIN(IF('Citi - Sheet1'!$D$2:$D$10091=45,'Citi - Sheet1'!$E$2:$E$10091))
but when I combine these 2 criteria I get 0 - which is incorrect
=MIN(IF(AND('Citi - Sheet1'!$C$2:$C$10091=B107,'Citi - Sheet1'!$D$2:$D$10091=45),'Citi - Sheet1'!$E$2:$E$10091))
Thanks,
Yosef