You may be better off with a Pivot Table. But if you want a worksheet
function:

=SUMPRODUCT(--(A1:A6="Screws"), --(C1:C6="A"), B1:B6)

In article ,
"Jonathan" wrote:

I'm trying to get a formula in Excel that will add up e.g. that there are
£22.00 of screws type A and £13.00 of screws type B. Then £10.50 of nuts
type D and £6.50 of nuts type A. I think I need sumproduct but I'm not an
expert.

Can anyone help please?


A B C D
1 Screws 10.00 A
2 Screws 12.00 A
3 Screws 13.00 B
4 Nuts 5.00 D
5 Nuts 5.50 D
6 Nuts 6.50 A


TIA
John