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. ...
If you have excel365 then you can use the FILTER function. Although you could do it all in a single formula lets do the more simple formula that you can copy across and down:
=SUM(FILTER(Schedule!$C:$C, (Schedule!$E:$E=$A$1)*(Schedule!$F:$F=B$1)*(Schedule!$G:$G=$A2),0))
note this is untested and meant to show you basically how to do it. Hope that works for you.
=SUM(FILTER(Schedule!$C:$C, (Schedule!$E:$E=$A$1)*(Schedule!$F:$F=B$1)*(Schedule!$G:$G=$A2),0))
note this is untested and meant to show you basically how to do it. Hope that works for you.
Hi,
Nope that formula did not work. spreadsheet attached if you want to see the full thing and how I have set it up. Probably not the best way to go about it but I'm self taught and going with what I know.
Nope that formula did not work. spreadsheet attached if you want to see the full thing and how I have set it up. Probably not the best way to go about it but I'm self taught and going with what I know.