double counting

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

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

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

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

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

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

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