Forum Discussion
Solved
Sum With Multiple Arrays
I need to sum a column of data where the combination of two separate criteria are true. In the example below, I need to sum all the vehicles by month based on the city they were manufactured.
=TRANSPOSE(MMULT(TRANSPOSE($B$4:$D$6),IF($H$4:$J$6="False",0,1)))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Thank you so much @Quadruple_Pawn and Lorenzo! They are real TRUE/FALSE and that worked perfectly!!!
