Need formula help for adding months based on criteria of customer

[Lil Dot]

I have a spreadsheet that I need to add each month sales invoices based on customer.

Here is a sample of what my spreadsheet looks like.

I would greatly appreciate any help. Thank you in advance!

 

[Saba Sabaratnam]

Hi Lil Dot,

Copy the formula in cell G2 and copy it across and down to sum numbers based on both on months and customers.

=SUMPRODUCT(($C$2:$C$6),(--($B$2:$B$6=$F2)),--(MONTH($A$2:$A$6)=VLOOKUP(G$1,{"Jan",1;"Feb",2;"Mar",3;"Apr",4;"May",5;"Jun",6;"Jul",7;"Aug",8;"Sep",9;"Oct",10;"Nov",11;"Dec",12},2,FALSE)))

You will have to expand C2:C6 ranges in the formula to your desired range.

Kind regards

Saba

 

[Lil Dot]

Thank you very much Saba! Your formula works perfect!

 

[sandy666]

this is simply for Pivot Table

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Sum of Amount[/td][td=bgcolor:#DDEBF7]Date[/td][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Cust[/td][td=bgcolor:#DDEBF7]Jan[/td][td=bgcolor:#DDEBF7]Feb[/td][td=bgcolor:#DDEBF7]Mar[/td][/tr]

[tr=bgcolor:#FFFFFF][td]CustA[/td][td]

81.6​

[/td][td]

52.01​

[/td][td]

57.02​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]CustB[/td][td]

103.24​

[/td][td]

45.78​

[/td][td]

83.77​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]CustC[/td][td]

130.6​

[/td][td]

2.38​

[/td][td]

116.85​

[/td][/tr]
[/table]