Alter formula to exclude H

[Shazz]

Hi All,

I have a formula they I need to adapt so that is "H" is within the range of cells, it does not include this within the count.

Can anyone help. please.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=SUMPRODUCT(('Agency Input'!D3:EV3=TODAY())*('Agency Input'!D4:EV26<>""))[/FONT]

 

[steve the fish]

Add another test:

=SUMPRODUCT(('Agency Input'!D3:EV3=TODAY())*(COLUMN(D3:EV3)<>8)*('Agency Input'!D4:EV26<>""))

 

[Fluff]

Slightly different take on what is required.
=SUMPRODUCT(('Agency Input'!D3:EV3=TODAY())*('Agency Input'!D4:EV26<>"H")*('Agency Input'!D4:EV26<>""))