1. S

    How put "> or <" a variable into multiconditional SUMIFS

    Picking up on an old thread (apologies if I was supposed to just tack onto the old one) Trying to find sum of the values in Column A for a March sale (indicated in Column B) if the cell in Column C is >0 OR the cell in Column D is >0, and Column E is >10. I think it would be something like...
  2. A

    macro to search with two criteria

    Hi friends, I have big problem, please help me. I am new in excel vba and I am learning. This is the problem: I have sheet like this: <TABLE class=MsoNormalTable style="MARGIN: auto auto auto 4.8pt; WIDTH: 145.5pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm...
  3. B

    multicondition summing/counting using cell references

    I would like to COUNT (could be SUM) the number of instances where column A = $D$1 while column B = $E$1. So going by the table below the answer should be 3. I found I can do it when I insert "D-2" into a SUMPRODUCT formula but not when I refer to cell $D$1. If I can help it I would like to...

Some videos you may like

This Week's Hot Topics