Adding daily totals

[ffgilby]

Hi,
OK, here is the problem I have today. I have built a several page worksheet to track payments for an office. This adds the total in payments from several columns and gives the total for the entire worksheet. What I am looking for is a function to pull the total from one column if criteria matches another column. Here is what I'm trying to find: SUM(E13:E112) if(B13:B112)=A5. Then the same idea just A5+1, then A5+2 and so on. Exactly what I need is the total for people paying cash on one day, then each sequential day there after. Cash amount will be in column E, with dates in column B, with the beginning date in A5. I have tried several functions with no luck.

Any direction with this would be appreciated.

 

[MARK858]

Maybe I'm reading it wrong but is it not just a normal Sumif formula i.e.

=SUMIF($B$13:$B$112,A5,$E$13:$E$112)

 

[MARK858]

Or Across multiple sheets (Sheetnames in L5 - L7 in the totals sheet)...

=SUMPRODUCT(SUMIF(INDIRECT("'"&$L$5:$L$7&"'!$B$13:$b$112"),A5,INDIRECT("'"&$L$5:$L$7&"'!$E$13:$e$112")))

 

[ffgilby]

That worked perfect. I used that same formula before, but the wrong order.

THANKS!!