Is there a macro that will compute values for weekends only?

[RiaMelissaJaravata]

I attached here the sample workbook that has formulas :
=SUM(B2;B5:B9;B12:B16;B19:B23;B26:B30)

which sums values for weekdays, and formula:

=SUM(B3:B4;B10:B11;B17:B18;B24:B25;B31:B32)

which sums values for weekdays. Is there anyway to code that in macro? A code that will automatically sum values for weekends, and separately for weekdays, in any month? I hope you can help me. Thank you so much!!!

 

[Deepak]

Hi,

Why VBA if same is easily archival with formula.

B35 =SUMPRODUCT((WEEKDAY(A2:A32,2)<6)*B2:B32)

C35 =SUMPRODUCT((WEEKDAY(A2:A32,2)>5)*B2:B32)

 

[NARAYANK991]

Hi ,

See the attached file.

The function is a UDF , called CalculateSums , and can be called in 3 different ways :

=CalculateSums(DatesRange , ValuesRange) ---- this will just sum up all the values

=CalculateSums(DatesRange , ValuesRange , True) ---- this will sum up the values for all weekdays

=CalculateSums(DatesRange , ValuesRange , False) ---- this will sum up the values for all weekends

Narayan

 

[RiaMelissaJaravata]

Hi ,

See the attached file.

The function is a UDF , called CalculateSums , and can be called in 3 different ways :

=CalculateSums(DatesRange , ValuesRange) ---- this will just sum up all the values

=CalculateSums(DatesRange , ValuesRange , True) ---- this will sum up the values for all weekdays

=CalculateSums(DatesRange , ValuesRange , False) ---- this will sum up the values for all weekends

Narayan

Thank You Narayan!!! Works like magic! You are a genius!

 

[RiaMelissaJaravata]

Hi,

Why VBA if same is easily archival with formula.

B35 =SUMPRODUCT((WEEKDAY(A2:A32,2)<6)*B2:B32)

C35 =SUMPRODUCT((WEEKDAY(A2:A32,2)>5)*B2:B32)

Thank you, Sir Deepak! This helped me understand the "weekday" formula.

 

[Deepak]

Thank you, Sir Deepak! This helped me understand the "weekday" formula.

Thnx buddy..