Hi
trying to put a SUMPRODUCT formula in my workbook and I am now tying myself in knots.
Column A Column B Column C
Feb Ness 7
Feb Don 3
Feb Tay 1
Feb Clyde 2
Feb Ness 1
I want to be able to add Column C for all that have the properties Feb, Ness, Don + Tay
SUMPRODUCT(($A6:$A$5404=G7),($C$6:$C$5404="Ness")+($C$6:$C$5404="Don")+($C$ 6:$C$5404="Tay")),$E$6:$E$5404))
I finally got to this but it's wrong.
Any help appreciated