|
|
#9
03-16-2024, 11:15 AM
|
|||
|
|||
Another slightly shorter formula is
=SUMPRODUCT(($A$26:$A$34=K$1)*(OR((LEFT($B$26:$B$3 4)={"4""5"})))*$D$26:$G$34) where I guess you must change \ to , (comma). \ is because I use Danish settings. Edit: {"4""5"} here I wrote {"4" backslash "5"} but it was changed when I posted. I think you should use {4,5}. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to hide/delete slides based on keyword in a separate text file based on AND|OR condition? | rupd911 | PowerPoint | 0 | 02-22-2021 08:22 AM |
| QR codes in Word | lreinhard7 | Word | 1 | 12-19-2019 06:46 AM |
| Enter a city based on a short list of zip codes | jcgwilym | Excel | 1 | 04-19-2017 10:53 AM |
 Need help with Field Codes
|
Cosmo | Mail Merge | 25 | 07-30-2015 01:25 PM |
| Is it possible to merge the two VBA codes into just one | sam2149 | Excel Programming | 0 | 02-26-2014 05:28 AM |
Windows 11 
Office 2021
Threaded Mode