SUMIFS statement

JCan

Hello,

I am trying to use SUMIFS to pull reference a numbers on another sheet.

I want to say if the PO number is = X, pull the invoice total from the invoice total column and Sum it in this column on another sheet. (So I can see a sum of total put to that PO number).

Any help would be appreciated!

Thank you!

Sameer Karkhanis

Try this:

Assumption: PO Number and Invoice Total columns are in Sheet 1 and your formula is used in Sheet 2

=SUMIF({PO Number Column Range from Sheet 1}, "X", {Invoice Total Column Range from Sheet 1})