-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
array sum
-
M
How to sum a series of numbers in alphanumeric strings - in a single formula?
Team, Working on a roster, to allow people to (a) specify a shift type and (b) record TOIL (time off in lieu) gained or taken in the same cell. Basic layout for the roster is; Name | 1Jan | 2Jan | etc The "codes" for the shifts can be 1 or 2 characters i.e. "D" = dayshift, "CN" covering...- michaelg
- Thread
- array sum days formula hours toil
- Replies: 4
- Forum: Excel Questions
-
F
Array formula with array constant
I need help with creating an array formula for a spreadsheet I'm developing. The percentages are constants. In the calculated total column I want the sum of 100%*10 + 88%*20 + 68%*29 + 50%*15 + 20%*6 for each line. Any help or guidance will be greatly appreciated. - Fred <tbody> 100% 88%...- Fdjaynes
- Thread
- array constants array formula array sum
- Replies: 12
- Forum: Excel Questions
-
I
Sum with multiple dates
Hi people. Thanks again for the help. I'm facing a new problem with a very large sheet. In fact, I want to sum the column "Extension" when a couple of criterias is true, The example: Place Extension Date1 Date2 Date3 Date4...- igbaria
- Thread
- array sum array sumif sumif
- Replies: 3
- Forum: Excel Questions
-
K
Sum array with date column header greater than lookup cell and distinct number
Need help in getting sum if array to work. I need to sum the data array for all matching "stores", (Column B), and to make sure it is greater than the date constraint, (Column C). I tried ... =SUM(IF($B$9:$B$23=B4,IF($C$8:$M$8>C4,$C$9:$M$23))) CSE This works on the example I attached. My...- kapanenship
- Thread
- array sum date format sumifs sumproduct
- Replies: 0
- Forum: Excel Questions
