Hello,
I need to consolidate monthly targets data for salespersons by summing 2, 3 or more months together.
Details: I have a table with salespersons and their monthly targets, January through December. Sometimes I need to sum data from specific months, for example January+February+March or...
Hello Experts,
I need a formula that will sum values based on a the dates of expected monthly dollar increases or decreases contained in a table for a matrix of companies.
I have the following formula but it fails when there are many dates and only works if there are only a few dates...
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...
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...
=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
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?
=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...
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
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...
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...
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...
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...
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")...
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...
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...
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
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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.