Sum values from column based on criteria

RtchSS

Hello,

I am trying to sum values from a reference sheet based on common criteria. However I am running into either "#INCORRECT ARGUMENT SET" or values that are not the exact sum as expected.

My idea is to SUM the values from the attached request sheet (column 12), into the corresponding rows (column SUM) in the attached tracker sheet based on the matchup with criteria in column 4 in request sheet.

I have tried SUM function with VLOOKUP, obviously gives different values than I expected, and I am still struggling to understand why (Probably it's my lack of understanding the behaviour of the functions).



I would appreciate any kind of help or a point in the right direction.

Thanks!

Andrée Starå

Hi,

Can you describe your process in more detail and share the formulas that you're using? That would make it easier to help. 

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

RtchSS

Hi Andree,

Thanks for the reply!

Basically the process is as simple as already described with the screenshots, nothing besides that. At least for now.

I am trying to SUM the values from one sheet in a different sheet based on certain condition. (as marked on screenshot, based on Criteria1 for example)

So far as I was trying variations of SUMIF and SUMIFS formulas, but without any luck, and also SUM with VLOOKUP, but as already pointed out due to my own lack of understanding I am most probably missusing the formula.

Here is an example

=SUM({request Range 1}, VLOOKUP([Primary Column]1, {request Range 2}, 8, false))

I would essentially appreciate any push in the right direction.

Thanks!

Paul Newcome

Try something along the lines of 

 

=SUMIFS({Request Range 1}, {Request Range 2}, [Primary Column]@row)

 

{Request Range 1} should be Column12, and {Request Range 2} should be Column4.

RtchSS

Hi Paul,

Works!

Thank you so much for the suggestion.

Seems like I have to learn a bit more about the SUMIFS and criterions.

Paul Newcome

No worries. Practice makes perfect.

 

Happy to help. 

Andrée Starå

Happy to help!

Paul beat me to answering.

Best,

Andrée

Jekster1989

I am having the same issue. I have tried SUMIFS, but I don't believe I am using it correctly.



I have a column labeled status and a column labeled sell. I have 4 or 5 options under status, but I only want to find the total for status's that are marked as "Sent".

Andrée Starå

Hi,

Can you share the formula you're using now?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting