Sumif or Countif - need help with correct formula

[eileen123]

Hello! I am trying to figure out which formula to use to meet these criteria: If anything (not blank) is in Column B range: B2:B100 (stays constant), I want it to add a sum of a range of cells (G2:P2) and populate it in cell R2. Then I want to drag the formula down column R to apply to the corresponding rows. I am not sure the formula I am using is correct.

I would use the same formula for certain criteria for Column A and U. Thanks for your time & help!

 

[eileen123]

Perfect! Thank you.
One final question (if possible) - in your row 4 - is there a way if there is data in both cells A & B that the sum populates in column R (not U)?

 

[Siddharth Rout]

Perfect! Thank you.
One final question (if possible) - in your row 4 - is there a way if there is data in both cells A & B that the sum populates in column R (not U)?

Yes it is possible.

Put this in cell R2 and drag it down

=IF(A2<>"",IF(B2<>"",SUM(G2:P2),""),IF(B2<>"",SUM(G2:P2),""))

Put this in cell U2 and drag it down

=IF(A2<>"",IF(B2<>"","",SUM(G2:P2)),"")

 

[eileen123]

Wow! Thank you so much Sid! Very helpful

 

[Siddharth Rout]

Wow! Thank you so much Sid! Very helpful

No Problem. Glad to be of help

 

[Fluff]

@eileen123 For future reference when asking questions about Google sheets you need to post in the General Discussion & Other Applications section of the board. You should also make it clear that it is for Sheets, I have done that for you this time.

 

[eileen123]

Understood, thank you!

 

[eileen123]

Sid & Fluff, Would it be okay if I asked a follow-up question pertaining to this thread here?

 

[Fluff]

If it's directly related to your original question, that's fine. Otherwise you need to start a new one.

 

[eileen123]

Perfect, thank you. Here is my question, in the same spreadsheet I want to populate another worksheet FY23 PA Grp Funds by Program (cell B3) from data gathered from the first worksheet (Program Funds Total FY22/23) we worked on as follows:

FY23 PA Grp Funds by Program screenshot where I want the formula and results to populate in cell B3:

If there is anything in column A (PA Cohort) I would like it to sum the range under column M (Pitch Funding) and populate the cell B3 in the FY23 PA Grp Funds by Program worksheet