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

#### Lil Dot

##### New Member
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!

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### Saba Sabaratnam

##### Board Regular
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

##### New Member
Thank you very much Saba! Your formula works perfect!

#### sandy666

##### Well-known Member
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​

1,101,819
Messages
5,483,084
Members
407,379
Latest member
Bender1964

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...