Calculating multiple fields' data based on checking another field's value matching a source field

Question

So I am trying to match up and check work/allocations by checking Grower/Supplier Tag Details against the "Product ID" section above. Currently running into a large formula problem and wondering if there's a better option. I am using "T" to test, so that's the end destination. Eventually there will be 10 Ts, one for each Product ID.&nbsp;on T1, the goal is to test F, G,H,I to see if they equal A. Any that do should have their corresponding values J,K,L, or M added up and subtracted against Nrinse and repeat for T2, "" they equal B. "" subtracted against Oetc.
My problem is a problem of if thens simply being to long to complete for all of the potential scenarios. If I'm correct, the scenarios would be 10 factorial.------------------------------Davis Ward------------------------------

markshnier__you · Answer

Is this what you mean- (IF(=, , 0)- (IF(=, , 0)- (IF(=, , 0)- (IF(=, , 0)//on T1, the goal is to test F, G,H,I to see if they equal A. Any that do should have their //corresponding values J,K,L, or M added up and subtracted against N------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

davisward · Answer

I think so, let me build out that formula and see if I'm getting the results I'm expecting.------------------------------Davis Ward------------------------------

davisward · Answer

Yes, that is it. Thanks for that. I should have thought of that before, but it works perfectly.------------------------------Davis Ward------------------------------

Forum Discussion

Calculating multiple fields' data based on checking another field's value matching a source field

3 Replies