Forum Discussion
Multiple IF CONDITIONS formula for different tabs
Hi Experts, I am trying to set up a cross reference table in 1 tab [TOTALS] that will automatically calculate totals based on 3 criteria in a different tab [SCHEDULE] in the same spreadsheet. ...
Hi Oliver, Just been thru all the formulas again trying out different variations and changing names and looking at the formulas. Still not working no matter what I do and Excel just keeps popping up the warning message THAT FUNCTION ISNT VALID.
Im using Microsoft Excel 2016. Does that make a difference with the formulas ?
Any help you can provide is greatly appreciated.
Im using Microsoft Excel 2016. Does that make a difference with the formulas ?
Any help you can provide is greatly appreciated.
I would suggest a pivot table.
"Level" and "Use / Function" in rows area.
"Department" in columns area.
"Floor Area" ín values area.
Set the report layout in tabular form. This could be not part of Excel 2016.
Set subtotals only for "Level".