I Dont know how to ask this, but to sum cells against one cell

[Baba_Yaga]

Hello,
This is just a snip of a much larger sheet. the column letters are the same. you can see in column AS that the total is 16, but that one is split into multiple locations for one type ( column E )
in this example the total of all the Like E ( all the A01 ) equal 16 and the o29 type also equal 16 Im trying to figure out a way to flag the ones that their type total ( all the matching E for F ) are either more than
their AS qty I hope this makes sense.

So in a nut shell F part number is linked to E Type and the sum of V for the e & f must match and not be less or more.

Thanks in advance

 

[venkatmail]

you can use sumif formulae to sum in a single cell but before that, highlight a unique first cell some how and filter that cell alone and then apply the sumif formulae to capture this details in a single cell only instead of all the cells.

 

[Sufiyan97]

try this in column AS

=SUMIFS(V:V,E:E,E2,F:F,F2)