Excel 2007 : Sumproduct Remove Case Sensitivity

[TommyG]

Hi all,

I have been using this formula,

=SUMPRODUCT(EXACT(G6:CR6,{"H";"HD"})*{1;0.5})

on an attendance sheet i use for work, it counts "H" as 1 and "HD" as 0.5 which is great.

However i want it to also recognise lowercase "h" and "hd", I've been trying a few things but nothing seems to work, any ideas appreciated.