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

  • Thread starter Thread starter mwhit79
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

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

Match Dates in Two Cells and Ignore subsequent Cells 1
Sum based on date in another cell 5
accepting most recent date across columns 10
Finding a sum by matching two cells with the same identifier 1
Conditional Sum date range 2
Remove date format? 3
Sum Totaled based on Matching Identical Criteria in Worksheet 1
count total dates for each month 2

Back
Top