# Thread: Need formula help for adding months based on criteria of customer Thanks: 0 Likes: 0

1. ## Need formula help for adding months based on criteria of customer

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!

2. ## Re: Need formula help for adding months based on criteria of customer

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

3. ## Re: Need formula help for adding months based on criteria of customer

Thank you very much Saba! Your formula works perfect!

4. ## Re: Need formula help for adding months based on criteria of customer

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