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

Sum of Amount	Date
Cust	Jan	Feb	Mar
CustA	81.6​	52.01​	57.02​
CustB	103.24​	45.78​	83.77​
CustC	130.6​	2.38​	116.85​