I'm trying to create a dynamic SUMIF formula with multiple criteria than can be changed. I've found that I can use "*" if I want to find the sum of anything in that field. But the "*" doesn't seem to work with numbers.
Please take a look at the example sheet I've attached. I can change the vehicle type and colour or put "*" to sum all, but I have to specify a number for the year if I want to get a sum. I can't use "*" for the year.
Any ideas?
Bookmarks