ExcelBanter - Calcuate totals based on specific criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calcuate totals based on specific criteria (https://www.excelbanter.com/excel-worksheet-functions/239364-calcuate-totals-based-specific-criteria.html)

Dhardy

Calcuate totals based on specific criteria

Hello,
I am trying to get Excel to add data in column "M" if the data in column "A"
is between 8/1/2009 & 8/8/2009. Can anyone help with this formula? Thanks in
advance!

Jacob Skaria

Calcuate totals based on specific criteria

With the query dates in C1 and D1 try the below formula...

=SUMPRODUCT(--(A1:A100=C1),--(A1:A100<=D1),M1:M100)

If this post helps click Yes
---------------
Jacob Skaria

"Dhardy" wrote:

Hello,
I am trying to get Excel to add data in column "M" if the data in column "A"
is between 8/1/2009 & 8/8/2009. Can anyone help with this formula? Thanks in
advance!

All times are GMT +1. The time now is 12:58 AM.