Difference between total revenue - last days revenue

**vinodt** · 10-08-2012, 01:46 PM

Hi I'm trying to write a formula that calculates the total revenue and gives me the difference between total accumulative revenue and revenue accrued yesterday for each account ID

I've attached a file for your reference.

**Ace_XL** · 10-08-2012, 02:05 PM

difference between total accumulative revenue and revenue accrued yesterday for each account ID

Wouldn't this always equal revenue for current date? Can you update your sample worksheet with expected results?

**vinodt** · 10-08-2012, 02:28 PM

I'm sorry I wasn't clear in enough earlier. Things that I'm trying to accomplish (possibly in another sheet) are, 1) total revenue for the previous day. 2)Spend change across all accounts (absolute number & not in percentage)

**Ace_XL** · 10-08-2012, 02:35 PM

This should give you total cumulative revenue for each account no. for previous day

=SUMPRODUCT(--($A$2:$A$25=A2),--($B$2:$B$25<B2),$C$2:$C$25)
or
=SUMIFS($C$2:$C$25,$A$2:$A$25,A2,$B$2:$B$25,"<"&B2)

Spend change across all accounts (absolute number & not in percentage)

dont understand this...can you upload expected results?