SumIf with discontinuous cells?
I tried something like...
=SumIf(a5,a10,a15,a20,"0",b5,b10,b15,b20)
and...
=SumIf((a5,a10,a15,a20),"0",(b5,b10,b15,b20))
added complicating factor...I can't use a 'name the ranges' approach here
(longer story)
"Dave F" wrote:
Show us an example of a formula you tried.
Dave
--
Brevity is the soul of wit.
"RBee" wrote:
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?
|