@ Jeet Singh,
It's surprising, you took almost a day time to***edit **Ashish Koul*
Suggestion???
On 08-01-2013 2:13 PM, jeet singh wrote:
=SUMIFS(C2:C11,A2:A11,">="&F2,A2:A11,"<="&G2)-SUMIFS(B2:B11,A2:A11,">="&F2,A2:A11,"<="&G2)
REGARDS
JEET SINGH
On Mon, Jan 7, 2013 at 7:06 PM, Yahya M
=SUMIFS(C2:C11,A2:A11,">="&F2,A2:A11,"<="&G2)-SUMIFS(B2:B11,A2:A11,">="&F2,A2:A11,"<="&G2)
REGARDS
JEET SINGH
On Mon, Jan 7, 2013 at 7:06 PM, Yahya Muhammad wrote:
>
> Dear experts
>
> I have an excel file to track the bank transactions. It has a debit column
> for the withdrawals and credit co
Thanks excel learner.
On Tue, Jan 8, 2013 at 7:16 AM, Ms-Exl-Learner wrote:
> *Compatible, Faster & Shorter Length formula
>
> **=SUMPRODUCT((A2:A11>=F2)*(A2:A11<= G2),(-B2:B11)+(C2:C11))*
>
>
>
>
> On 07-01-2013 9:00 PM, Yahya Muhammad wrote:
>
>
> Thanks Ashish. Is there any way we can combi
_*Compatible, Faster & Shorter Length formula
*_*=SUMPRODUCT((A2:A11>=F2)*(A2:A11<= G2),(-B2:B11)+(C2:C11))*
On 07-01-2013 9:00 PM, Yahya Muhammad wrote:
Thanks Ashish. Is there any way we can combine two SUMPRODUCTS/SUMIFS
into one, to reduce the length of formula ?
On Mon, Jan 7, 2013
Thanks Ashish. Is there any way we can combine two SUMPRODUCTS/SUMIFS into
one, to reduce the length of formula ?
On Mon, Jan 7, 2013 at 4:41 PM, ashish koul wrote:
> try this
>
> =SUMIFS(C:C,A:A,">="&F2,A:A,"<="&G2)-SUMIFS(B:B,A:A,">="&F2,A:A,"<="&G2)
>
>
>
> On Mon, Jan 7, 2013 at 7:06 PM, Ya
try this
=SUMIFS(C:C,A:A,">="&F2,A:A,"<="&G2)-SUMIFS(B:B,A:A,">="&F2,A:A,"<="&G2)
On Mon, Jan 7, 2013 at 7:06 PM, Yahya Muhammad wrote:
>
> Dear experts
>
> I have an excel file to track the bank transactions. It has a debit column
> for the withdrawals and credit column for the deposits. I c
Dear experts
I have an excel file to track the bank transactions. It has a debit column
for the withdrawals and credit column for the deposits. I can get the
running totals by adding another column and just using simple excel
formulae. However, sometimes I want to find the running totals in the
ac