index and matching probems

[bumptyblue]

hi im hoping someone can help me with a index and match error that I cant seem to work out

Please see attached file

Im trying to get my total sales and total cost of sale from the data in B2 to D16
into H6 and H8

appreciate it if anyone can point out what im doing wrong
thanks
bumptyblue

[Bo_Ry]

You need Sumifs

H6 copy to H8
=SUMIFS($D$3:$D$16,$B$3:$B$16,$H$4,$C$3:$C$16,G6)

[BadlySpelledBuoy]

Hi and welcome

INDEX/MATCH is not quite the right tool for the job here.

Try this in H6 then copy and paste into H8:

Please Login or Register  to view this content.

BSB

[popipipo]

With sumifs; sumproduct or pivottable you can get the right solution

[bumptyblue]

thanks thats worked