| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel IF Then Statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If Then Statement in Excel | Excel Worksheet Functions | |||
| Excel Report Using IF Statement? | Excel Discussion (Misc queries) | |||
| SQL Statement and Excel | Charts and Charting in Excel | |||
Linear Mode
