=sumifs question

[steve400243]

Hello Forum, I am trying to get this formula to sum column F, if column A has a 1 and Column N also has a 1.

=countifs(‘Receipt Report’!$F:$F,’Receipt Report’!$A:$A,”1”,’Receipt Report’!N:N,”1”)

Thank you for any help provided.

 

[steve400243]

I greatly appreciate your help on this formula. Col A would be the same for some rows, but would be different numbers. Not just "A123". could be that for several rows, then "B456", for example, for several rows.

.

 

[Aladin Akyurek]

In Q1 enter and copy down:

=SUMIFS('Receipt Report'!F:F,'Receipt Report'!A:A,"A123",'Receipt Report'!N:N,P1)

where P1 = 1, P2 = 2, and P3 = 3.
​

 

[steve400243]

In Q1 enter and copy down:

=SUMIFS('Receipt Report'!F:F,'Receipt Report'!A:A,"A123",'Receipt Report'!N:N,P1)

where P1 = 1, P2 = 2, and P3 = 3.
​

Aladin, thank you. The container number in col A on the Receipt report would vary, it could be the same for several rows, then change. Col N would always be 1,2, or 3

 

[Aladin Akyurek]

Aladin, thank you. The container number in col A on the Receipt report would vary, it could be the same for several rows, then change. Col N would always be 1,2, or 3

If you are unsure how to organize your conditions, just follow the suggestion below:

P1 = 1, Q1 = 2, and R1 = 3

O2 = A123

O3 = B456

etc.

In P2 enter, copy across to R2, and down:

=SUMIFS('Receipt Report'!$F:$F,'Receipt Report'!$A:$A,$O2,'Receipt Report'!$N:$N,P$1)

 

[steve400243]

Aladin, That works as needed! Thanks very much for your time, and this formula. Have a great day!

 

[Aladin Akyurek]

Aladin, That works as needed! Thanks very much for your time, and this formula. Have a great day!

You are welcome. Thanks for providing feedback.