SUMIF/SUMIFS with multiple criteria

[Leonjay]

Hi,

Im stuck with a formula can anyone help?

I want to sum the bottom row in the image below when two criteria is met, which is 'A' and 'Qty' The problem is the sum range needs to be the bottom row only(figures). The criteria 1 (A,B,C) is a merged cell if that makes any difference!

Any ideas anyone?

Thanks
Leon

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]qty[/TD]
[TD]qty[/TD]
[TD]qty[/TD]
[TD]qty[/TD]
[TD]qty[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]21[/TD]
[TD]45[/TD]
[TD]56[/TD]
[TD]65[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

The expected result is:
A-qty = 86?

But I can't imagine how you have the merged cell.
You could upload an image or a sample file.

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[Leonjay]

Hi Dante,

Yes, that's correct 86.

The cell is merged due to the lay out of the sheet but it doesn't have to be.

 

[Leonjay]

View on Dropbox

 

[Fluff]

You need to mark your file for sharing & then post the link you get.
At the moment, it is asking me to sign in.

 

[Leonjay]

You need to mark your file for sharing & then post the link you get.
At the moment, it is asking me to sign in.

Hi Fluff,

Try this...

https://www.dropbox.com/s/33ac0pc8nsoul9v/Payment valuation sheet Template 2.xlsm?dl=0

 

[DanteAmor]

It would help a little if you explain on which sheet, in which cells the information is, where you want the result and what is the expected result.
It would also help if you put information on the sheet and explain it with an example.

 

[Leonjay]

It would help a little if you explain on which sheet, in which cells the information is, where you want the result and what is the expected result.
It would also help if you put information on the sheet and explain it with an example.

HI,

Sorry I would have explained in more detail!

Internals Detail Sheet


I want to sum row 19 but only in the 'Qty' column (criteria 1) and when 'Type A' (Criteria 2) is met.

Basically BCS column is the total quantity for each plot and the 'qty' column is the amount complete to date. I want the completed to date qty for each 'plot type' to be collected on the 'valuation build up' sheet which will produce an invoice for the work completed to date.

Valuation Build-Up

I have baked on this sheet where the formula needs to be (C,154)

Please see link below to the sheet.

Many thanks

https://www.dropbox.com/s/jl53aedwhpcjcs3/Payment valuation sheet Template 3.xlsm?dl=0