Search:

Type: Posts; User: MARZIOTULLIO; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    4
    Views
    220

    Re: SUMPRODUCT and EXACT problem

    Can you provide some sample data and what the expected outcome is?
  2. Re: Count if Value meets or exceeds criteria

    <tbody>


    a


    b


    c
  3. Re: count cells that string contains X but does not contains Y or Z

    <tbody>


    A


    B


    C
  4. Re: SUMPRODUCT with multiple criteria in Rows and Columns (Still function as SUMPRODUCT instead of SUM or COUNT)

    <tbody>


    A


    B


    C
  5. Replies
    7
    Views
    145

    Re: WeekNumber From Time Sheet Value

    <tbody>


    A


    B
  6. Replies
    7
    Views
    139

    Re: Search product price by latest date

    SALES REGISRATION

    D3=IF($A3<>"",IF('SALES REGISTRATION'!$A3=MAX(IF('STOCK '!$B$3:$B$11='SALES REGISTRATION'!$B3,IF('STOCK '!$C$3:$C$11='SALES REGISTRATION'!$C3,'STOCK...
  7. Re: Index Matching with Multiple Criteria and Greater Than

    <tbody>


    A


    B


    C
  8. Re: Countifs ignoring duplicate dates in specific range

    <tbody>


    A


    B


    C
  9. Replies
    7
    Views
    181

    Re: Matrix formula to count months

    You are welcome

    Grazie per la risposta
  10. Replies
    7
    Views
    181

    Re: Matrix formula to count months

    <tbody>


    A


    B


    C
  11. Re: How many names have a duplicate in a date range

    <tbody>


    A


    B


    C
  12. Re: SUMIFS less than date AND amount is more than zero

    Can you provide some sample data and what the expected outcome is?


    maybe

    =SUMIFS(C3:C136,C3:C136,">0",A3:A163,"<=30/06/2006")
  13. Re: problem formula Index not work after point to relation many column

    You are welcome.
  14. Re: problem formula Index not work after point to relation many column

    Hi

    B6=SUMPRODUCT(($D$3:$D$12=B3)*(E3:E12=B4)*(F2:I2=B5)*(F3:I12))
  15. Re: problem formula Index not work after point to relation many column

    Can you provide a real file not image and what the expected outcome is ?
  16. Re: Count Unique Values That Meet Criteria

    <tbody>


    A


    B


    C
  17. Replies
    2
    Views
    239

    Re: sumifs with 2 sum ranges

    <tbody>


    A


    B


    C
  18. Replies
    12
    Views
    280

    Re: Lookup a number, return a name

    <tbody>


    B


    C


    D
  19. Replies
    12
    Views
    280

    Re: Lookup a number, return a name

    <tbody>


    B


    C


    D
  20. Replies
    12
    Views
    280

    Re: Lookup a number, return a name

    Hi

    Can you provide some sample data and what the expected outcome is?
  21. Re: Challenge: Sum cells in one column when adjacent cells are not blank

    <tbody>


    A


    B


    C
  22. Replies
    6
    Views
    322

    Re: Lookup and create a list

    Hi

    E3=IF(E$2<>"",IFERROR(INDEX($B$2:$B$100,SMALL(IF($A$2:$A$100=E$2,ROW($B$2:$B$100)-ROW($B$2)+1),ROWS($B$2:$B2))),""),"") control+shift+enter copy across and down
  23. Replies
    10
    Views
    707

    Re: SUMIFs - simple example

    Another way


    <tbody>


    A


    B
  24. Replies
    10
    Views
    707

    Re: SUMIFs - simple example

    <tbody>


    A


    B


    C
  25. Re: Referencing Value in "Column Groups" (INDEX MATCH..?)

    <tbody>


    A


    B


    C
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4