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

### 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