Excel IF statement

  • Thread starter Thread starter sby
  • Start date Start date
S

sby

Hi

I am struggling with an IF Statement in Excel. I want to have a sheet which
says if it is mon -thurs add these totals and if it is Friday add these
totals together.

Does anyone know a way around this

Thanks

SBY
 
Maybe

=IF(WEEKDAY(TODAY(),2)<=4,A1+A2,IF(WEEKDAY(TODAY(),2)=5,B1+B2,"It's the
weekend!"))

Mike
 
for Friday you can use SUMIF

for mon-thur use if dates in col E and values in col F
=SUMPRODUCT((WEEKDAY(E2:E22)>=2)*(WEEKDAY(E2:E22)<=5)*F2:F22)
 
Back
Top