search and sum :)

domdc1

Board Regular
Joined
Apr 10, 2006
Messages
61
Hi everyone - ive done this before & for the life of me cant remember how.....
I need to add up all the values within a month. For example Jan would come back with 60 (5+25+30) feb with 25, march with 10 & april with 10


Feb 20 ----------------- jan 60
Jan 5 ----------------- feb 25
Mar 10 ----------------- march 10
April 10 ----------------- april 10
Jan 25
Jan 30
Feb 5

Any help as usual is appreciated
thx
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Formula in D1:
=SUMIF(A:A,C1,B:B)

Copy down.
Book3
ABCD
1Feb20Jan60
2Jan5Feb25
3Mar10Mar10
4Apr10Apr10
5Jan25May0
6Jan30Jun0
7Feb5Jul0
8Aug0
9Sep0
10Oct0
11Nov0
12Dec0
Sheet1
 
Solution

Forum statistics

Threads
1,137,339
Messages
5,680,910
Members
419,940
Latest member
WilliamPorter

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top