sumproduct

[xxsalahxx]

Apologies for previous post - I posted wrong thing altogether.

I have the following sumproduct below and I'm trying to add to this to to ignore any blank cells if possible. thank you

=SUMPRODUCT(--('3a6'!I2:I35>='3a6'!H2:H35))

 

[Aladin Akyurek]

Like this...

=SUMPRODUCT(--('3a6'!I2:I35>='3a6'!H2:H35),--ISNUMBER('3a6'!I2:I35),--ISNUMBER('3a6'!H2:H35))

 

[xxsalahxx]

Thank you so much

 

[Aladin Akyurek]

Thank you so much

You are welcome.