Wolfgang17
Board Regular
- Joined
- Nov 8, 2010
- Messages
- 60
Looking for help with summing based on criteria. Right now I have this which is summing based on data from a data sheet. It works great.
=SUMPRODUCT(SUMIF(INDIRECT("N5:N47"),CHOOSE({1,2,3},Data!$P$3,Data!$P$4,Data!$P$5),INDIRECT("M5:M47")))+SUM($H$5:$H$47)
However I would like to add another column, and Sum the above only if it meets the Criteria found in column B. The criteria is a code number 712 from the data sheet.
Would a nested if statement work? If so, how would that look?
Any help would be appreciated.
=SUMPRODUCT(SUMIF(INDIRECT("N5:N47"),CHOOSE({1,2,3},Data!$P$3,Data!$P$4,Data!$P$5),INDIRECT("M5:M47")))+SUM($H$5:$H$47)
However I would like to add another column, and Sum the above only if it meets the Criteria found in column B. The criteria is a code number 712 from the data sheet.
Would a nested if statement work? If so, how would that look?
Any help would be appreciated.