Chirag R Raval
Member
Dear & Respected experts,
I have a file (daily new file), with subtotal on amount,
require sum of every data block , on every blank cell, if
another column have particular word in column..
hope below image described well my requirement.
found blank cell on column "K" & put there sum or sumproduct formula there
for sum of amount column "G", for that block only , if column "K" have work "Over Due"
& only sum amount of related that word only.
Hope there are some vba solution found.
Regards,
Chirag Raval
I have a file (daily new file), with subtotal on amount,
require sum of every data block , on every blank cell, if
another column have particular word in column..
hope below image described well my requirement.
found blank cell on column "K" & put there sum or sumproduct formula there
for sum of amount column "G", for that block only , if column "K" have work "Over Due"
& only sum amount of related that word only.
Hope there are some vba solution found.
Regards,
Chirag Raval