Cross Sheet reference involving dates shows INVALID DATA TYPE
I am working on some inventory check and report.
Inventory sheet as follows:
Metric sheet to report on monthly incoming by items and month as follows:
I am trying to refer to the Inventory Sheet to sum Qty In if:
1) Level is 1 (I don't want the parent row to be calculated)
2) Equipment Description matches the primary column
3) Month matches [Nov20]2
4) Year matches [Nov20]1
But I keep getting invalid data type error.
Can anyone assist? Thanks.
Help Article Resources
Check out the Formula Handbook template!