Excel formula help

[ferocious12]

Hi Guys,

I have to analyse receivables & payables by range of amount they are falling into. Say how much receivable from $1000-$2000 etc.

The master data is dynamic & I have to change the number of rows SUMIF formula takes into account in column E everyday. Can you please suggest something that the SUMIF formula count the rows in Column A and takes into account. Currently, I am updating it manually.

Thanks

 

[bosco_yip]

Try..........

1] E3, copied down :

=IF(D3="","",SUMIFS(A:A,A:A,">="&C3,A:A,"<="&D3))

2] G3, copied down :

=IF(D3="","",COUNTIFS(A:A,">="&C3,A:A,"<="&D3))

Regards
Bosco

 

[ferocious12]

Try..........

1] E3, copied down :

=IF(D3="","",SUMIFS(A:A,A:A,">="&C3,A:A,"<="&D3))

2] G3, copied down :

=IF(D3="","",COUNTIFS(A:A,">="&C3,A:A,"<="&D3))

Regards
Bosco

You are a STAR. Thanks!