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.
