Excel IF statement
 

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

Excel IF statement
 

Maybe

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

Mike

"sby" wrote:

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

Excel IF statement
 

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)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sby" wrote in message
...
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