I am struggling to find the missing piece to a formula based on two dropdowns with both having the ability to include all the criteria. Can some evaluate this for me? =if(and(D6="All",D8="All"),sumifs(GL!$P:$P,GL!$I:$I,D$15,GL!$AB:$AB,$B17),if(D6=All,sumifs(GL!$P:$P,GL!$I:$I,D$15,GL!$AB:$AB,$B17, GL!$R:$R, $D$8)), if(D8=All,sumifs(GL!$P:$P,GL!$I:$I,D$15,GL!$AB:$AB,$B17, GL!$A:$A,$D$6)),sumifs(GL!$P:$P,GL!$I:$I,D$15,GL!$AB:$AB,$B17, GL!$A:$A, $D$6,GL!$R:$R,$D$8))
Blog
23431 posts
I sometimes have a flash drive that is a bootable drive, and would like to use the drive for something else (erasing the files on it) but without losing the option to use it in the future. The simple way would be to backup the files on it and later […]
VBA: Combine Excel files from multiple folders into one worksheet based on having the same 4 first characters in the file name.xlsx Description: There are files with a customer ID from 001-100. Each customer has 3 different Excel reports (### Report1-3), which are generated into different folders (Folders1-3). For example: […]
I want to convert ffmpeg -i input.mp4 -maxrate 63317762 -bufsize 63317762 -map_metadata -1 -vcodec libx265 -c:a copy -crf 28 -color_range 2 output.mp4 into a command that uses cuda to speed the conversion process. I tried ffmpeg.exe -hwaccel cuvid -i input.mp4 -pix_fmt p010le -c:v hevc_nvenc -preset slow -rc vbr_hq -b:v 6M […]