|
|
#6
03-08-2024, 09:29 AM
|
|||
|
|||
Sum based on starting no. of codes
Dear Pecoflyer,
Though I got the solution, for 4 series and for 5 series I have to plot separate formula to get the result for sum of 4 series and 5 series. 1. Can it be in single formula ? 2. Currently to get the result, I have to put formula in each line in I and J column. Is it possible to select criteria at range level i.e. month range A5:A13, Code range B5:B13, sum table D5:G13 and month criteria H3 to get the sum of 4 & 5 series ? Demo file is attached for your reference. Thanks in advance 
|
|
|
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 10 
Office 2021
Threaded Mode