KPIs of First 30 Days - Unique.

Hi all,

Long time lurker, first time poster. Would appreciate some assistance with a problem I have.

• I am trying to track performance of vendors for their first 30 days.
• Each vendor has a unique start date and multiple KPIs - I am attempting to sum these values
• My raw data is organised by vendor and shows all days they have been active in the year, redacted example attached.
• I also have the start date of each vendor.
• There is 400+ vendors in total

Convoluted methods I have attempted include attempting to count the first 30 instances of each vendor using =concatenate(vendorname, vendor start date) and Vlookups to return a value for the start date and using cell/address/index match to return the cell of start date and start date +30. I can't help but think there's a super simple method I am missing right under my nose.

Any input greatly appreciated.

ty,ned

Thank you!

1. Yes, I am hoping to sum separately. They are consecutive.
2. KPI1 = 41,774 ; KPI2 = $23.92
3 Unique is referring to the fact that there are unique start dates, and therefore 30 day periods, for each vendor.

Just a note that there's about 10 KPIs I'll be tracking, just added 2 to the example. Some of which will be =average, =max etc, but same principles will apply.

Many thanks,

Answered in 1

They are consecutive - no gaps.

Thanks.

Thank you Ali - you're a genius

If I wanted to make the change of cell "iffs" dynamic, allowing me to drag the entire formula down a list of vendors how would you structure it?

I have added all the vendors to column I as per the newly attached document and substituted "iffs" for cell I3 but it is no returning 0.

Assistance is greatly appreciated

New file now attached/

Ah - rookie mistake.

Thanks for your help once more. If it's not too much trouble would you mind explaining the formula and steps in practical terms so that I am learning something as opposed to just copying and pasting your work.

Gracias

It does indeed - thanks!