| Home > Forum Home > Analyzing Corporate Financial Data > Placing filter solutions in spreadsheet > Column value and IF statement | Share |
Column value and IF statement
Excel Help for Column Value And If Statement in Analyzing Corporate Financial Data
| Forum Topic | Login |
Column Value And If Statement | Rate this: (3/5 from 1 vote) |
 | You could create a separate column with the value for the day - e.g. 0.5 for Saturday etc.� To sum based on the day and person values you could either use a Pivot table with sub and grand totals, or use the SUMIF function (perhaps combined with the AND function) to return the total for matching values in the columns. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Column value and IF statement in the Excel Business Solutions Directory |