hello

i have a problem with formulas containing two conditions i tried sumif and
countif but it's not working
=COUNT(IF((sheet1!$F$8:$F$300="Materials")*(sheet1!$M$8:$M$300="PPE not
available"),sheet1!$A:$N))

appreciate your help in advnace
thanks