ExcelBanter - Get subtotal by two criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Get subtotal by two criteria (https://www.excelbanter.com/excel-programming/359142-get-subtotal-two-criteria.html)

sean_f

Get subtotal by two criteria

Hello,

I need to get a subtotal by 2 criteria and display that.
So for example a subtotal which displays the total of all fords bought
in april.

Anyone know how to do this?

Many Thanks

Sean

Toppers

Get subtotal by two criteria

Use SUMPRODUCT:

=SUMPRODUCT(--(B1:B20="Ford"),--(MONTH(A1:A20)=4))

HTH

"sean_f" wrote:

Hello,

I need to get a subtotal by 2 criteria and display that.
So for example a subtotal which displays the total of all fords bought
in april.

Anyone know how to do this?

Many Thanks

Sean

Jim Thomlinson

Get subtotal by two criteria

Check out this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson

"sean_f" wrote:

Hello,

I need to get a subtotal by 2 criteria and display that.
So for example a subtotal which displays the total of all fords bought
in april.

Anyone know how to do this?

Many Thanks

Sean

All times are GMT +1. The time now is 05:27 AM.