Hi there,
I need to pull the budget column for any particular month to include total of r6, r8-r10 (exc r7). I came up with
=sumif(b2&b4,l2,b6;j6)&sumif(b2&b4,l2,b8;j8)&sumif (b2&b4,l2,b9;j9)&sumif(b2&b4,l2,b10;j10)
I'm looking for some shorter formula to be able to pull up the same sum.
Many thanks,
|