I am trying to set up a formula, such as below but can't get past the first
"if function. Can someone help
So far this is what I have
=IF(A2="BIRS",E20,0)

I have 2 critierias that must be true : A2 must = specific words and E 2
must be greater than zero. If both are true then I need the number that is
in cell E 2 to copy to a different workbook in a new cell