CountIf formula

[rashid67]

I want take Pivot table total and divide it by count of days in the month and spread amount across by date. Here is example

# of days count = 10 *** # of days count will change each week so the formula should adjust accordingly
Amount = 5000 **** $50,000/10 should be spread only up to Apr 10 in this example, onward it should zero

4/01/18	4/02/18	4/03/18	4/04/18	4/05/18	4/06/18	4/07/18	4/08/18	4/09/18	4/10/18	4/11/18	4/12/18	4/13/18	4/14/18	4/15/18
5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	0	0	0	0	0

Thanks,
Rashid

 

[iggy_]

Assuming your data looks something like this:

50000		4/1/2018	4/2/2018	4/3/2018	4/4/2018	4/5/2018	4/6/2018	4/7/2018	4/8/2018	4/9/2018	4/10/2018	4/11/2018	4/12/2018
4/10/2018		5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	0	0

<colgroup><col><col span="10"><col span="3"></colgroup><tbody>
</tbody>

you can do this in cell C2 and copy across.

=IF(C1<=$A$2,$A$1/DAY($A$2),0)