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
 
Top