Forum Discussion

Lienvds's avatar
Lienvds
Copper Contributor
Dec 14, 2018

How to copy a cell's value IF...

Hi everyone,   I've been looking for a solution for this function problem I have and I hope someone can help me out? I'm making a sheet where we keep track of different kinds of money flow during a...
excel
Formulas and Functions
erol sinan zorlu's avatar
erol sinan zorlu
Iron Contributor
Dec 17, 2018

so as I understand right you want to have a sum of all the values that has "kluisje" in corresponding column you can use sumif or sumifs. If Iunderstand right. 

Lienvds's avatar
Lienvds
Copper Contributor
Dec 18, 2018

I tried this: =SUM.IF(E6:E25;N6:N25;E39:E58 = "kluisje"; C6:C25;L6:L25;C39:C58)

But I get an error message. How do I use this formula on all the columns to get the total sum?

 

 

  • Lienvds's avatar
    Lienvds
    Copper Contributor
    Dec 20, 2018

    I have fixed it in another way and it is working now. Thank you for your help!

     

    Lien

  • erol sinan zorlu's avatar
    erol sinan zorlu
    Iron Contributor
    Dec 19, 2018

    can you please share the file?