double counting

  1. D

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

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

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

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

    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. Johnny Thunder

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

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

Some videos you may like

This Week's Hot Topics