how do I add cells in a given date range i.e. all cells dated Nov.

M

mwhit79

I want to create a formula that would add information in rows that contain
the same month. For instance I want the process to take all lead entries
dated for November and add the total number of entries as well as add the
dollar amount of the entries.
 
J

Jarek Kujawa

number of entries:
=SUM(IF(MONTH($A$1:$A$100)=11,1,0))

sum of dollar amounts:

=SUM(IF(MONTH($A$1:$A$100)=11,$A$1:$A$100,0))

CTRL+SHIFT+ENTER these formulae as thay are array-formulae
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum based on date in another cell 5
Code to add comments to selected cells within a selected range 30
How do I add values fr/ cells with a given fill color (rose)? 1
Create a SUM of cells horizontally 5
How do you add related cells in a sum? 3
how can I lock/unlock a range of cells depending on state of a checkbox? 4
adding cells in autofilter 1
How do I average a row of 13 enries using the 8 highest in value. 2

Top