What formula can pickup the data as required ?
Hello everyone,Dear Excel overlords (and ladies) I have a data source of cars that need various types of tests, Test 1, 2 and 3 onwards (Refer data table in picture). This starts from 2019 and goes upto 2031. There are about 80 odd cars in the data.
What i need, is a year wise number of tests, segregated by the type of tests - refer table at the bottom.
Is there any formula that can do this ? I tried sumifs, but that wasn't accurate since i don't need it by Car number, just Test Type
Looking forward to being schooled ! Cheers