How do I sum based on a condition?
If B2 is equal to 21, then I want to sum(a1:a21). If B2 is equal to 43, then I want to sum(a1:a43). If B2 is qual to 67, then sum(a1:a67). And so on...
It seems so simple. I figure I am overlooking something obvious but don't know what. I would appreciate any input.
kc
If B2 is equal to 21, then I want to sum(a1:a21). If B2 is equal to 43, then I want to sum(a1:a43). If B2 is qual to 67, then sum(a1:a67). And so on...
It seems so simple. I figure I am overlooking something obvious but don't know what. I would appreciate any input.
kc