SUMIF with Multiple Ranges & Criteria

[SRafter]

Morning All,

I am looking to combine 2 SUMIF formulas to show results for an individual or the whole team:

The SUMIF for individual is :
SUMIF(Data1!$A:$A,$A$2&D$14,Data1!$G:$G)/SUMIF(Data1!$A:$A,$A$2&D$14,Data1!$I:$I)

The SUMIF for the team is:
SUMIF(Data1!$C:$C,D$14,Data1!$G:$G)/SUMIF(Data1!$C:$C,D$14,Data1!$I:$I)

Can someone please help with how I can nest all this together is the same cell? Thanks in advance.

Steve.

 

[Gerald Higgins]

Can you explain what exactly you want this to do ?

I understand summing for an individual, and it sounds like you've got that working.
I understand summing for a team, and it sounds like you've got that working too.
I don't understand what you want it to do, when you say nesting it all together.

 

[SRafter]

Hi Gerald,

I have a spreadsheet where I can select the name of an individual or "Team" from a data validation in cell drop down. The selection made here determines what data is returned and from which column in the imported query.

The formula above is placed in cell D3 across to cell R3 for monthly results by individual or team but I can't work out how to reference all the data I need to with only 1 formula in D3.

Hope you can help.

Cheers, Steve.