Formulas / or VBA codes .

[moizesdarius]

Doc Date	Amount	Currency	Profit Center
11/8/2018 11/8/2018 11/8/2018 11/9/2018 11/9/2018 11/9/2018 11/8/2018 11/8/2018 11/8/2018 11/9/2018 11/9/2018 11/9/2018 11/8/2018 11/8/2018 11/9/2018 11/9/2018 <tbody> </tbody>	34,221.57 14,278.86 4,330.33 19,126.05 13,278.90 2,668.19 23,787.76 9,216.01 2,635.83 43,584.87 4,276.21 4,982.49 2,714.65 355.36 1,788.60 610.75 <tbody> </tbody>	PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP <tbody> </tbody>	RS00000101 RS00000101 RS00000101 RS00000101 RS00000101 RS00000101 RS00000102 RS00000102 RS00000102 RS00000102 RS00000102 RS00000102 RS00000103 RS00000103 RS00000103 RS00000103 <tbody> </tbody>

<tbody>
</tbody>

Could someone give me formula/ VBA code on getting the sums depends if they have the same Profit Center and by
defining the date. Ex. 11/08/2018-11/09/2018 then check if the Profit Center are the same and giving the result of the total amount of each record. Thanks guys

 

[Joe4]

Welcome to the Board!

Take a look at the SUMIFS formula. Here is an example that shows you how to do a date range. And you can add additional criteria for your Profit Centers.
https://exceljet.net/formula/sum-if-date-is-between