Hi

If I understand you correctly, then in cell F1 on SheetA
=SUMPRODUCT(--(SheetB!$A$2:$A$897=D1),--(SheetB!$B$2:$B$897=D1)) +
SUMPRODUCT(--(SheetB!$B$2:$B$897=E1))

If this isn't correct, post back with more details


Regards

Roger Govier



JTKrupa wrote:

how do I combine these two functions?