SumIf

  • Thread starter Thread starter RAYMOND KELLY
  • Start date Start date
R

RAYMOND KELLY

I am trying to figure out how to sum certain values in column B, if column A matches a certain criteria.

i.e. Column A has dates in sequential order for all of 2003. Column B has sales per day.
I want to add the sales from column B for all of the Mondays.

Any help would be greatly appreciated.

Thanks.
 
One way:

=SUMPRODUCT((TEXT(A1:A20,"ddd")="Mon")*(B1:B20))

HTH
Jason
Atlanta, GA
-----Original Message-----
I am trying to figure out how to sum certain values in
Click to expand...
column B, if column A matches a certain criteria.
i.e. Column A has dates in sequential order for all of
Click to expand...
2003. Column B has sales per day.
 
Raymond,

Try the following formula:

=SUMPRODUCT((WEEKDAY(A1:A365)=2)*B1:B365)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





I am trying to figure out how to sum certain values in column B,
if column A matches a certain criteria.

i.e. Column A has dates in sequential order for all of 2003.
Column B has sales per day.
I want to add the sales from column B for all of the Mondays.

Any help would be greatly appreciated.

Thanks.
 
Hi
try
=SUMPRODUCT(--(WEEKDAY(A1:A1000)=2),B1:B1000)

--
Regards
Frank Kabel
Frankfurt, Germany

I am trying to figure out how to sum certain values in column B, if
column A matches a certain criteria.

i.e. Column A has dates in sequential order for all of 2003. Column B
has sales per day.
I want to add the sales from column B for all of the Mondays.

Any help would be greatly appreciated.

Thanks.
 
Back
Top