Multiple Critiera Sum Array - One critiera to be between two numbers
 

I have a report that uses the following formula to sum up a large
series of data in a standard report. The data entered needs to be
exact but I have just had a person ask for a sum between a certain
range and I'm having troubles trying to figure it out using a modified
version below.

{=SUM((act.ccb=VALUE('BA Report with budget'!
BCostCentre))*(act.ccc=VALUE('BA Report with budget'!
$C272))*(act.ccd=VALUE('BA Report with budget'!BFund))*(act.act))}

Logically, I want to be able to modify where
"act.ccb=VALUE(BCostCentre)" to something like .....
"acct.ccb=BETWEEN(BCostCentre1,BCostCentre2)" and it will sum up the
data between that specific range.

Would this be at all possible?

Multiple Critiera Sum Array - One critiera to be between twonumbers
 

(acct.ccb=<BCostCentre1)*(acct.ccb=BCostCentre2)

hope you replaced "act" with "acct" deliberately

Multiple Critiera Sum Array - One critiera to be between twonumbers
 

On Jul 16, 2:47*pm, Jarek Kujawa wrote:
(acct.ccb=<BCostCentre1)*(acct.ccb=BCostCentre2)

hope you replaced "act" with "acct" deliberately

This isn't working - an example below...

=SUM((act.ccb=VALUE(C7))*(act.ccd=VALUE(rep.fund)) *(act.ccc<VALUE(sal..start))*(act.cccVALUE(sal.en d))*(act.eb))

When I remove the act.ccc< and act.ccc the formula works but with
this in, it's not working.

Multiple Critiera Sum Array - One critiera to be between twonumbers
 

I ended up using a "select case" function in VBA to determine which
category in would be in.
It made life so much easier!