Addition of Quantities based on Month

abhilashlovesall

New Member
 6/4/2015 20 April May 10/4/2015 40 250 610 15/4/2015 60 20/4/2015 50 30/4/2015 80 01/5/2015 90 6/5/2015 100 15/5/2015 120 18/5/2015 140 29/5/2015 160

<tbody>
</tbody>

Hi friends,

I am searching for a formula that sums quantities based on month. for example In the month of April there are 5 entries 20,40,60,50 and 80. I want a formula that sums up all the entries of April separately and May separately. Kindly respond urgently. Thanks in advance.

Regards

Abhilash

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Zakkaroo

Active Member
=SUMPRODUCT(--(MONTH(A1:A10)=4))

(4 represents april. May = 5 etc)

abhilashlovesall

New Member
Thank you very much. Zakkaroo. Can I use SUM IF Formula for this. If I have to do that How should I go about.

Regards

Abhilash

Last edited:

abhilashlovesall

New Member
=SUMPRODUCT(--(MONTH(A1:A10)=4))

(4 represents april. May = 5 etc)

The formula does not work can you give me a formula with sum IF function

Zakkaroo

Active Member
Thank you very much. Zakkaroo. Can I use SUM IF Formula for this. If I have to do that How should I go about.

Regards

Abhilash

My apologies, I mis-read your post and thought you wanted a COUNT rather than a sum of the numbers! My bad.

=SUM(IF(MONTH(\$A\$1:\$A\$9)=4,\$B\$1:\$B\$9,0))

Try this, it is an array formula though, so you must confirm it with Ctrl + Shift + Enter, not just enter.

Replies
9
Views
538
Replies
5
Views
263
Replies
4
Views
670
Replies
0
Views
311
Replies
2
Views
650

1,195,669
Messages
6,011,059
Members
441,580
Latest member
BornholmerBjarne

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.

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

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