Sumif with multiple columns in sum_range
Ron,
You are a godsend! Yes that worked beautifully. I was ready to move on and
try something else but really had no idea.
Again, I really appreciate you sticking with me, trying different things and
such. Helping me to open my mind. I love user groups, a place to give help
and get help.
Thanks again Ron,
Have a great weekend!
AFJr
"Ron Coderre" wrote:
It's time to try another approach:
Try this ARRAY FORMULA (committed with CTRL+SHIFT+ENTER,
instead of ENTER):
=SUM(IF($B$21:$B$62="C",IF(ISNUMBER($Q$21:$S$62),$ Q$21:$S$62)))
Does that help?
-------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
|