Hi Mark

Try
=IF(B22="","",(SUMPRODUCT((B22=1)*(F22="EX"),1))
+(SUMPRODUCT((B22=1)*(F22="CURRENT"),2))
+(SUMPRODUCT((B22<1)*(F22="CURRENT"),B22))
+(SUMPRODUCT((B22<1)*(F22="EX"),B22)))
--
Regards
Roger Govier

Mark D wrote:
Afternoon all

I have the below forumula

=(SUMPRODUCT((B22=1)*(F22="EX"),1))+(SUMPRODUCT((B 22=1)*(F22="CURRENT"),2))+(SUMPRODUCT((B22<1)*(F2 2="CURRENT"),B22))+(SUMPRODUCT((B22<1)*(F22="EX") ,B22))

However if there is nothing in cell B22 I am getting VALUE appear. So I need
to add to the above formula that if there is nothing in B22 to simply put
nothing in the cell

Thank you in advance