I would like help with a formula that will sum all in collumn B, if there is a quantity greater than $1500 in collumn C and also a quantity greater than $1500 in collumn B.
If a door does not have quantities in both collumns B and C individually greater than $1500, then I do not want it to be in the grand total (like for like) below.
a b c
Door # ty ly
3118 $65,735 $59,759
3122 $0 $0
3124 $62,215 $56,559
3126 $0 $45,060
3127 $65,857 $59,870
3132 $88,626
like for like $193,807 $176,188
Any good ideas out there?
Tiffanie
Bookmarks