# summing

1. ### Formula "Ignoring" Values when Summing

Hi guys, I've got a wierd problem with this spreadsheet. An extract is available here: https://drive.google.com/open?id=1y_cvduilM1k3nnH8-hH0dbfdJPN9815t In column U there's a simple formula to sum the values in the preceding cells. The problem is that the first 4 rows are not summing...
2. ### Summing the bottoms of two columns

Hey guys!! Alright so I have a rather simple problem that I just cant seem to figure out for the life of me. Its fairly straightforward. So I have a data table, <tbody> 5 241 3 244 4 248 3 251 225 </tbody> I want to take the 251 in its cell, add it to the 225s cell, and then put...
3. ### summing a Vlookup column

I have a vlookup column that I would like to sum the dollar amounts that vlookup puts in the column. Thanks
4. ### Sum If Is Not Summing Horizontally

=SUMIF(B2:B4,B2,F2:J2) Hello All, I ran into an issue using SUMIF. The formula above only pulls the number in F2. I want the SUMIF to sum horizontally, instead of vertically. I thought it would sum horizontally? thanks
5. ### Summing values from previous rows?

Hi, Wondering best way to do this? I read about using offset but will be volatile right Example: A10: =SUM(\$A\$2:A9) Any easier way to do this in a table?
6. ### If i can get Formula Sytanx right for summing then why not for....

Anyone who can help me to correct If i can get Formula Sytanx right for summing then why not for the following Thanks NimishK
7. ### HOW to make this formula exact match?

=SUMPRODUCT(SUMIF(ABQSTATS!\$A:\$A,ALFONSOABQ,ABQSTATS!K:K))+SUMPRODUCT(SUMIF(GJSTATS!\$A:\$A,ALFONSOGJ,GJSTATS!K:K))+SUMPRODUCT(SUMIF(DENSTATS!\$A:\$A,ALFONSODEN,DENSTATS!K:K)) So this is looking for R8 as part of the named range but also finding R80 and matching and summing both numbers. How do I...
8. ### Shorten formula - summing dates

How can I shorten the formula: =SUM(DAY(EOMONTH(A156,0)),DAY(EOMONTH(A157,0)),DAY(EOMONTH(A158,0)),DAY(EOMONTH(A159,0)),DAY(EOMONTH(A160,0)),DAY(EOMONTH(A161,0))) I tried doing sumproduct, but I must be doing something wrong Thanks
9. ### Question: Has SUMIFS formula changed for blank cells?

Has anyone noticed a changed to the logic or Summing blank cells using the SUMIFS(? the criteria used to be "<>", but i couldnt get it to work. Finally i tried "<>""", and it worked correctly. But thats not the way i remember the formula. Has anyone else noticed the logic changed for...
10. ### sum a value between two date

Hi all! I'm trying find a formula to multiply a number by the number of days between two dates. For example: <tbody> Number From Date To Date SUM 2.21 01/01/2018 28/02/2018 [result] </tbody> So I'm looking for a formula to provide a result summing 2.21 x 28. I hope this makes...
11. ### delete row based on values....almost there

Hi again, this code from Fluff has worked...I am summing all rows in column 77 and if the sum is 0.00, then a TRUE is assigned to the cell in the affected row in the summing column. =IF(SUM(E11:BX11)<0.000001,TRUE,"") I had to use .0000001 because it seems that excel doesn't want to...
12. ### =small function - skipping cells with formulae but no value

Hi i searched thru the forum but could not find any reference to my specific question. I want the 5 lowest values in a row. The cells in the row may or may not have values. When i use the =SMALL function it thinks my blank cell is one of 5 smallest. =SUM(SMALL(G4:U4,{1,2,3,4,5})) is the...
13. ### SUMIFS in VBA

Can some one explain, point the error & provide correct code. The below code is getting the result .Range("P2:p" & lr).Formula = "=SUMIFS(L:L,I:I,O2,M:M,\$P\$1)" But the below code is just summing up only the value of O2 .Range("P2:P" & lr) = WorksheetFunction.SumIfs(.Range("L:L"), .Range("I:I")...
14. ### Summing weekly data for a specific month

Hi all, I am receiving weekly data which I try to convert to a monthly one. My challenge is to identify cells related to, for example March and sum those in one cell related to March. I know the dates when data is reported ahead of time (e.g. every Friday). Since dataset will expand in future...
15. ### Summing Multiple Workbooks for a total

Hey Guys, Really needing help Auto Summing multiple workbooks that get dropped in a specific folder these workbooks are all the same format just contains different amounts in areas. So I would like to have one workbook that will auto calculate all workbooks in this folder to give me a total...
16. ### Summing Subtotals

Hi, I have basic knowledge of PowerPivot but I was wondering if there is a way to total the subtotals in a PowerPivot table? Maybe someone has an example? I good at reserve engineering. Thanks, Luke
17. ### Array summation issues

Hey guys, I'm trying to sum an array but the result is just the first value of the array. The code it pretty complex but here it is: {=INDEX(B11:B16,MATCH(SMALL(B11:B16/C11:C16,ROW(\$A\$1:INDIRECT("A"&\$B\$9))),(B11:B16/C11:C16),0))} (Ctrl+Shift+Enter) This part works fine, it forms a cell with...
18. ### SumProduct formula is counting instead of summing

With help from this forum I've used SumProduct many times but I've been going round in circles for the past couple of days with a formula which won't stop counting results instead of summing them, I'm sure I'm missing something obvious so any help would be greatly appreciated. I'm using Excel...
19. ### Count Formulas

Is there a way that I can count the number of cells that have a formula? Cell 1: 5 Cell 2: 8 Cell 3: Sum(a1:a2) Cell 4: 2 Cell 5: 9 Cell 6: Sum(a4:A5) I would like a formula that would return 2.
20. ### Looping through filtered rows with multiple columns

Using the advancedfilter I find rows in my data which have certain criteria. I'd like to make a calculation where i subtract to cells in each of and sum the result. Using the code below creates a loop which runs through all visible cells in all rows. I only need to run through each visible row...