Sumproduct and weekday from mm/dd/yyyy format?

  • Thread starter Thread starter wx4usa
  • Start date Start date
W

wx4usa

Can sumproduct return the weekday from just the mm/dd/yyyy format? I
have the date mm/dd/yyyy in column a and sales dollars in column b. I
would like just Tuesdays sales.
 
Can sumproduct return the weekday from just the mm/dd/yyyy format? I
have the date mm/dd/yyyy in column a and sales dollars in column b. I
would like just Tuesdays sales.
Click to expand...

Try this formula:

=SUMPRODUCT((WEEKDAY(A1:A10)=3)*(B1:B10))

Change the 10 in two places to match the number of rows you have.

Hope this helps / Lars-Åke
 
Try this formula:

=SUMPRODUCT((WEEKDAY(A1:A10)=3)*(B1:B10))

Change the 10 in two places to match the number of rows you have.

Hope this helps / Lars-Åke
Click to expand...

Wow that's really great! Thank you. Lars-Åke
 
Back
Top