IF and SUM Functions

Hi there,

I have an existing Klip Table ("Table 1") with data from a single source ("Source 1") aligned as follows:

  • Model Name
  • SKU
  • Launch Date
  • In Transit -- this is the column I'm trying to populate with data from Table 2

Table 1

I'm trying to set up a second Klip Table ("Table 2") (that will be hidden) which sums up the quantity in transit for a particular SKU from a different data source ("Source 2"). The idea is to just do a LOOKUP using the SKU column in Table 1 to get the total quantity In Transit for that SKU based on the aggregated data in Table 2.

Table 2

Essentially, I'm trying to get the total sum of Items - Quantity Expected (Column I) for each unique SKU in Column C (which would then tie into the "SKU" in Table 1). I've tried various combinations of SUMIF, SUM(IF), SUM(GROUP), etc., but can't seem to get the formula right.

If I was using Excel, I'd just do a SUMIF formula with my criteria as Column C and sum range as Column I, but I can't get that to translate to Klipfolio.

To summarize, I need help:

  1. Totaling the sum of Items - Quantity Expected in Table 2 by the grouped SKU; then
  2. Looking up the sum from Table 2 and pulling that value in to Table 1 using the SKU in that table.

Appreciate any help!

1 comment

  • Avatar
    Shima Beigzadeh Official comment

    Hi Ralph, 

    Thanks for posting in our community post! 

    The function you would need to use is LOOKUP () function.You would use LOOKUP () function only when you want to combine the data from 2 or 3 different datasources.

    It would be something like below: 
    LOOKUP( SKU: table1, Parent SKU: table 2, Qty Inbound: table 2) 

    The above would work correctly, as long as Parent SKU is already grouped in hidden Table 2 and Qty Inbound is grouped by Parent SKU ( It other words Qty Inbound sum-aggregated by Parent SKU. )

    Please try above and if you still have issues, send us a ticket at support@klipfolio.com and we would be happy to have a closer look into your Klip.



Please sign in to leave a comment.