I need to use the SumIF (and SumProduct) on a collection of summary row cells that have sub-component data between them and are therefore discontinuous. A comma is used to separate these values in the formula, but a comma is also used to separate the three components of the SumIf formula syntax....so it is not working. I tried putting extra parens around the range data, but still doesn't work. Any ideas?
PS...added complicating factor...I can't use a 'name the ranges' approach here (long story)
PS...added complicating factor...I can't use a 'name the ranges' approach here (long story)