+ Reply to Thread
Results 1 to 7 of 7

SumIf Function

  1. 03-06-2011, 11:17 AM #1
    jmaterano
    jmaterano is offline
    Registered User
    Join Date
    08-26-2010
    Location
    Venezuela
    MS-Off Ver
    Excel 2007
    Posts
    25

    SumIf Function

    Hello how are you?

    I have a problem, because I want to make a performance formula whit function SUM IF but I could make one that managed to score as required.

    I want to make a conditional formula to sum only if there is a load of gasoline without taking into account the last load of gasoline.

    Get to a formula with SUM.IF but not achieving what I want

    I attached a file with an example.

    If you need more explanation let me know.

    Thank you very much for your help.

    Regards,
    Attached Files Attached Files
    Last edited by jmaterano; 03-08-2011 at 10:58 PM.
    Reply With QuoteRegister To Reply
  2. 03-06-2011, 06:16 PM #2
    Blake 7
    Blake 7 is offline
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: SumIf Function

    Hola Juan - quetal por alli? pos estos latitudeds estamos pasanding un frio q te cagas.

    Dime - no ha entendido my muybien, por lo visto con tu requicito D6 tiene q leer 0.80? Asi q estes parando cada vex q un numero aprezca en col c? si tengo razon maniana me pongo a pensar!
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/
    Reply With QuoteRegister To Reply
  3. 03-06-2011, 06:37 PM #3
    jmaterano
    jmaterano is offline
    Registered User
    Join Date
    08-26-2010
    Location
    Venezuela
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: SumIf Function

    Hola Blake 7, Gracias por responder,que gusto que puedas hablar en español!, oye y aquí en Caracas esta haciendo mucho calor porque estamos en época de carnavales.

    Fíjate en el ejemplo quiero que en la columna D de exactamente lo que arroja en la columna E mediante una formula que use SUM IF porque cada vez que haya una recarga de combustible sume los Miles Traveled y los divida entre los lts sin tomar en cuenta lo que se haya recargado antes, por ejemplo en la celda D10 debería dar 20 porque solo debe sumar B9 y B10 y dividirlo entre C10.

    De verdad muchas gracias por tu ayuda.

    Saludos,

    JM
    Reply With QuoteRegister To Reply
  4. 03-07-2011, 02:40 AM #4
    Blake 7
    Blake 7 is offline
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: SumIf Function

    Vale, entendido. Gracias por la explicacion. Me fijo hoy a ver si podemos encontrar una solucion. Te aviso en un par de horas.
    Reply With QuoteRegister To Reply
  5. 03-07-2011, 04:41 PM #5
    Blake 7
    Blake 7 is offline
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: SumIf Function

    Hola Juan como andas. Tio, llevo todo el dia pensando en como lograr eso pero al final me rendi y lo puso en una parte de este forum donde los q "saben" van para ayudar los inutils como yoo! asi q estoy seguro q alguien nos va a ayudar. Estoy tan anxioso como vos para ver una manera de conseguir tu requcito.

    Saludos
    Reply With QuoteRegister To Reply
  6. 03-07-2011, 05:22 PM #6
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: SumIf Function

    ¿Cómo está, Juan?

    Try this formula in D2 copied down

    =IF(C2="","",(SUMIF(A$2:A2,A2,B$2:B2)-SUMPRODUCT((A$1:A1=A2)+0,C$1:C1,D$1:D1))/C2)
    Audere est facere
    Reply With QuoteRegister To Reply
  7. 03-08-2011, 08:15 PM #7
    jmaterano
    jmaterano is offline
    Registered User
    Join Date
    08-26-2010
    Location
    Venezuela
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: SumIf Function

    Thanks a lot for your help, that is a formula,, its works very well!

    Best regards,

    PD: Blake 7 Many thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1