aweinberger
New Member
- Joined
- Oct 27, 2006
- Messages
- 4
So, I was trying to use an array formula like used in the tip posted on this site. http://www.mrexcel.com/tip011.shtml
My need is a little more complicated. In the example,
sum(a2:a10*b2:b10) added the products of each respective row, using the CSE or array function.
In my case, I would like to do this, but have different categories, and would therefore like to use a sumif instead of a sum. Is this possible
My need is a little more complicated. In the example,
sum(a2:a10*b2:b10) added the products of each respective row, using the CSE or array function.
In my case, I would like to do this, but have different categories, and would therefore like to use a sumif instead of a sum. Is this possible