Excel IF statement

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
 
M

Mike H

Maybe

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

Mike
 
D

Don Guillett

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)
 
Top