G
Gunjani
How do I exclude certain cells in a range from a calculation
e.g =SUMPRODUCT(($A$26:$A$147=$A151)*($B$26:$BE$147=B$150))
but I wish to exclude columns
B26:C42,I26:J42,W26:X42,B47:C63,I47:J63,W:26:X42,B68:C84 etc
--
Many Thanks
Gunjani
It may be that we have all lived before and died, and his
is
hell.
-- A.L. Prusick
e.g =SUMPRODUCT(($A$26:$A$147=$A151)*($B$26:$BE$147=B$150))
but I wish to exclude columns
B26:C42,I26:J42,W26:X42,B47:C63,I47:J63,W:26:X42,B68:C84 etc
--
Many Thanks
Gunjani
It may be that we have all lived before and died, and his
is
hell.
-- A.L. Prusick