Good day to all,
I am using the following formula to count the total number of contract types if 'ITD $K' equals '0' zero. But it returns 0 as output.
=SUMPRODUCT('PROCUREMENT CONTRACTS'!$E$5:$E$225="GROSS")*('PROCUREMENT CONTRACTS'!$J$5:$J$225=0)
Can you please help me what I am doing wrong here?
Thank you.
I am using the following formula to count the total number of contract types if 'ITD $K' equals '0' zero. But it returns 0 as output.
=SUMPRODUCT('PROCUREMENT CONTRACTS'!$E$5:$E$225="GROSS")*('PROCUREMENT CONTRACTS'!$J$5:$J$225=0)
Can you please help me what I am doing wrong here?
Thank you.