Hello,
Sorry if the title doesn't make make sense.
I'm pricing a project which split into blocks, with many of the same specifications repeated by block. I have used V-lookup (on a different sheet) to generate the same rates for materials and labour, but is there any way to total up the overall quantity and cost of each specification, back onto my V-lookup sheet? Kind of like a subtotal but without jumbling up the data? I played around with data consolidation but the subject is in Column B and i need to total Y & AB so not sure this would work.
Ideally i need this to be live in case any quantities/rates change.
I hope that makes sense!
Any suggestions greatly received
Many thanks,
Emily xx
Sorry if the title doesn't make make sense.
I'm pricing a project which split into blocks, with many of the same specifications repeated by block. I have used V-lookup (on a different sheet) to generate the same rates for materials and labour, but is there any way to total up the overall quantity and cost of each specification, back onto my V-lookup sheet? Kind of like a subtotal but without jumbling up the data? I played around with data consolidation but the subject is in Column B and i need to total Y & AB so not sure this would work.
Ideally i need this to be live in case any quantities/rates change.
I hope that makes sense!
Any suggestions greatly received
Many thanks,
Emily xx
