Forum Discussion
Solved
Multiple condition statement?
I haven't used Excel in 5+ years. I'm trying to set up a spreadsheet for a school that itemises and provides costings for maintenance. There are likely to be 12 sheets; each with about 10 columns and...
Thank you - much appreciated.
alternatively with Excel365 you could use a VSTACK and then a PIVOTBY:
=LET(alldata, VSTACK('Teaching Block:Science Block'!A2:C10),
data,FILTER(alldata,TAKE(alldata,,1)<>""),
PIVOTBY(TAKE(data,,1),CHOOSECOLS(data,2),TAKE(data,,-1),SUM))you can turn the Totals off if you don't want to see either or both of those.
Thank you - much appreciated.