# double counting

1. ### Excel Formula Help

Afternoon All I've cobbled together the following formula to give a Subtotal with multiple options when a column is filtered but it seems to be counting some things twice. I'm sure there is a far more elegant formula I could use but the one I am using is below...
2. ### Double count issue. SUMIFS/SUMIF

Hi all, I am having a problem with a double counting sumif, because of and array. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 232px"><col width="100"><col width="100"></colgroup><tbody> #f4f4f4[/URL]...
3. ### Double count in SUMPRODUCT formula

Hi. There are two questions inherent to this thread. But let's go step-wise: I have this formula in which I want to sum items (Description) that contains ANY of the strings in the C16 to C17 range: = SUMPRODUCT( SUMIFS(Value; Description; "*"& C16:C17 &"*") ) This formula however, double...
4. ### HW involving For-Next loops, wage doubling, input boxes, message boxes.

Think you can solve it? I'm stumped on a homework assignment with VBA. The question goes as follows.. Write a VBA program using For-Next loops to find out how much money you would be paid, if your starting pay was a nickel and your paydoubled every day for a specified number of days. Input...
5. ### combination of sumif and sobtotal

I need your help with merging the sumif and the subtotal function. But not in the way which most posts in forums are about. This is NOT about filters... What I want to do is the following. I would like to use a normal sumif function with criteria in another column than the sumrange. The...
6. ### Double Vlookup between two Columns - Excel 2010

Hello All, I have two columns E:E and G:G that I have matching data in. Column G:G may contain duplicates so it usually has more lines than E:E. I was using this formula, =IF(G5="","",IF(ISERROR(VLOOKUP(E:E,G:G,1,0)),"Missing Acct "&E5,IF(ISERROR(VLOOKUP(G:G,E:E,1,0)),"Missing Acct...
7. ### How to prevent sumproduct from double counting

Hi! I have a SUM/SUMPRODUCT combination formula (below) to figure out the number of oil rigs in column B with the names D20 or D21, which also have revenue in column H and revenue in any of the other columns L, P, T and W. This works great. If I have a rig with revenue in column H, and also...

### This Week's Hot Topics

• separating multiple Proper names (uppercase letters) from a list
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
• 'for' Loop
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
• Open specific pdf in folder with vba
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
• What is wrong with this For Loop code?
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
• Data to match
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
• Shifting Columns
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

### We've detected that you are using an adblocker.

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

### 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.
Go back