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 TopicLogin

Column Value And If Statement

Rate this:
(3/5 from 1 vote)
ConfusedYou 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 on
 
View Full Post

Find relevant Excel templates and add-ins for Column value and IF statement in the