Forum Discussion
Advanced Sumifs Help Needed
CasonTheOnly , sorry, I missed you'd like to find sum for all invoices, not for concrete one. When warp your formula with SUMPRODUCT as
=SUMPRODUCT(SUMIFS(...))
Otherwise it takes first invoice from the list (203978) and you have no such in the range.
CasonTheOnly , that's like
=SUMIFS(Price,Code, ">="&100000,Code,"<="&399999,Vendor,"Yes")
As variant PivotTable could be more suitable
SergeiBaklan I may be structuring this wrong. I've attached a screenshot this time to give you an idea of what I'm working with (sorry for the 3mb file size....) Thanks for the response!
Cason
Hi Cason,
In the middle it shall be
...,E319:E353,">=400000",E319:E353,"<=499999",...
I guess you have no name "code" defined.
SergeiBaklan The formula is now having issues summing the totals. It keeps calculating $0. Referring back to my screenshot (I've reattached for your convenience), I previously found the issue was coming from the list of invoices I am trying to match (AE321: AE350), almost as if it would not correctly match each individual invoice number. I was then forced to build another sheet that would sum the totals within each individual invoice (AE321), (AE322), etc. instead of being able to select all of them at once (AE321: AE350). However, even with your formula recommendation selecting on ONE invoice # (AE321), it still sums to 0.
Thanks!
CasonTheOnly , sorry, I missed you'd like to find sum for all invoices, not for concrete one. When warp your formula with SUMPRODUCT as
=SUMPRODUCT(SUMIFS(...))
Otherwise it takes first invoice from the list (203978) and you have no such in the range.
