C
ccjrocha
If I am to add all the shipments for all different equipment types by
receipient and other criteria, eg
=SUMIFS(RECORDS!TOTALS,RECORDS!MONTH,$A$2,RECORDS!EQUIPMENTTYPE,C$2,RECORDS!RECIPIENT,$A4)
This formula is validating the receipient, the equipment type and even the
month it was shipped. Adding totals of all shipment by item description.
Our inventory starts on the 22nd of each month and ends on the 21st of the
following month.
Up to this point, I had to add a column to specify what month's inventory
the shipment must be applicable to, otherwise is considering the month to
start on the 1st and to end on the 31st.
I need to call January 22 through February 21, the dates applicable for the
month of February and so forth. So all shipments made during those dates
will be filling my applicable Inventory month column and I can use that as
the validation of the month on the formula noted above.
Hope it all makes sense and some sugestions come up.
Regards
ccjrocha
receipient and other criteria, eg
=SUMIFS(RECORDS!TOTALS,RECORDS!MONTH,$A$2,RECORDS!EQUIPMENTTYPE,C$2,RECORDS!RECIPIENT,$A4)
This formula is validating the receipient, the equipment type and even the
month it was shipped. Adding totals of all shipment by item description.
Our inventory starts on the 22nd of each month and ends on the 21st of the
following month.
Up to this point, I had to add a column to specify what month's inventory
the shipment must be applicable to, otherwise is considering the month to
start on the 1st and to end on the 31st.
I need to call January 22 through February 21, the dates applicable for the
month of February and so forth. So all shipments made during those dates
will be filling my applicable Inventory month column and I can use that as
the validation of the month on the formula noted above.
Hope it all makes sense and some sugestions come up.
Regards
ccjrocha