drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 528
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance!
I have 2 diferent sets of data
ps:
I do not want to use a help Column (Why: because using a help column I know the how to accomplish
I am using conditional formatting to highlight those cells, but how can I count/Sum them?
Thanks again
I have 2 diferent sets of data
- Sheet(1).Range("A2:A50") named "Range1"
- Sheet(2).Range("A20:C350") named "Range2"
- I would like to have in Sheet(2).Range("A1") a formula probably SumProduct to sum how many of my cells in Range2 are not contained in Range1
- I would like to have in Sheet(2).Range("A10") a formula probably SumProduct to sum how many of my cells in Range2 are contained in Range1
ps:
I do not want to use a help Column (Why: because using a help column I know the how to accomplish
I am using conditional formatting to highlight those cells, but how can I count/Sum them?
Thanks again