If Range (A1:A15) = "x" then add all of B1:B15

[GL3]

Hi, I need help with a formula and keep getting Spill errors.

What I am trying to do is say if the range A1:A100 = Anthony and E1:E100 = 1 (on another tab) then add H1:100 (on that other tab) that meet that criteria and divide by B15 on tab where formula is entered.

Basically I need this: =SUMIF('September Log'!$E$2:$E$100,"=1",'September Log'!$H$2:$H$100)/B16 only if A1:A100 = Anthony H. and E1:E100 then =1.

In the file I do have the names as a drop down table if that has any impact.

Thank you!

 

[etaf]

how about

SUMIFS( 'September Log'!$H$2:$H$100 , 'September Log'!$E$2:$E$100, 1,'September Log'!$A$2:$A$100 , "Anthony H") / B16

your text talks about row1 to row100 - formula is row 2 to 100 , and also the formula is B16 and the text says B15

you can add the dropdown cell reference rather than the actual name itself

so confused

 

[GL3]

how about

SUMIFS( 'September Log'!$H$2:$H$100 , 'September Log'!$E$2:$E$100, 1,'September Log'!$A$2:$A$100 , "Anthony H") / B16

your text talks about row1 to row100 - formula is row 2 to 100 , and also the formula is B16 and the text says B15

you can add the dropdown cell reference rather than the actual name itself

so confused

Yeah, I was confused too ha. I had kept tweaking it and eyes crossed but you got the idea. Your formula did the trick though so thank you very much! It mirrors the numbers from another report I am trying to simplify so that did it. Appreciate it again.

 

[etaf]

you are welcome