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




On 11 Gru, 20:40, mwhit79 wrote:
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.