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.
Hi, that is intentional. The number represents the possible number of people that could need each kind of vehicle. My real life need for the formula isn't about vehicles, but I am a car enthusiast so that is where my brain went. 🙂 Thanks for inquiring.
Got it. Thanks for putting my mind at rest!