I have a formula that is getting out of hand. At first I found it to work without and issue but now I have to replicate it a little more frequently and its getting quite cumbesome to do so.
I have Columns L,M,N,O,P, and Q that all have individual Dollars that are pulled into this sheet at times. I have them summing based on the Month, and by the Salesperson. The month is tagged on manually by me in this sheet when I put information into it into column S, and the salemen information is in column E. The below is a snapshot of the sheet, starting in Column A with the Completion Date. and S being the Manually entered Month.
<tbody>
</tbody>
I can't seem to figure out how to get the sheet to calculate across the multiple columns, and I am sure its an easy fix but, my question is how can I add the last three columns in each Row based on the criteria of the salesmen and the month? Currently I am adding like this, but need to add the last three columns in order to catch everything that I need. Cerrently I am doing it like this and there has to be a better way.
=SUMIFS('Service Dollars'!$L:$L,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$M:$M,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$N:$N,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$O:$O,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$P:$P,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$Q:$Q,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")
Thank you in advanced and please reach out if this isn't making any sense.
Seth
I have Columns L,M,N,O,P, and Q that all have individual Dollars that are pulled into this sheet at times. I have them summing based on the Month, and by the Salesperson. The month is tagged on manually by me in this sheet when I put information into it into column S, and the salemen information is in column E. The below is a snapshot of the sheet, starting in Column A with the Completion Date. and S being the Manually entered Month.
| 20190222 | CROPP019 | W06931 | 03 | JRI | 306 | 32 | $114.00 | 3.12 | 3.12 | 0 | $300.00 | $0.00 | $0.00 | $135.00 | $0.00 | $0.00 | February | |
| 20190222 | PANIP002 | W06991 | 03 | JRI | 2149 | 35 | $60.00 | 13.25 | 1 | 1 | $720.00 | $0.00 | $0.00 | $360.00 | $0.00 | $0.00 | February |
<tbody>
</tbody>
I can't seem to figure out how to get the sheet to calculate across the multiple columns, and I am sure its an easy fix but, my question is how can I add the last three columns in each Row based on the criteria of the salesmen and the month? Currently I am adding like this, but need to add the last three columns in order to catch everything that I need. Cerrently I am doing it like this and there has to be a better way.
=SUMIFS('Service Dollars'!$L:$L,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$M:$M,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$N:$N,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$O:$O,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$P:$P,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")+SUMIFS('Service Dollars'!$Q:$Q,'Service Dollars'!$S:$S,"February",'Service Dollars'!$E:$E,"JRI")
Thank you in advanced and please reach out if this isn't making any sense.
Seth
