ozbeachbum
Board Regular
- Joined
- Jun 3, 2015
- Messages
- 237
- Office Version
- 2021
- Platform
- Windows
Hi All,
I have a formula and need to adjust it so it will meet 2 criteria.
Searching the net and trying variations with my level of expertise, has been to no avail, I would greatly appreciate any assistance.
I apologise, I would have attached a mini sheet but I am still trying to work out the installation issue since upgrading.
=SUMPRODUCT((MOD(ROW(S70:S333)-70,6)=0)*(J70:J333="CBD"),(S70:S333))
I need the formula to also include that it only SUM cells that have a positive figure.
Cheers,
Dave.
I have a formula and need to adjust it so it will meet 2 criteria.
Searching the net and trying variations with my level of expertise, has been to no avail, I would greatly appreciate any assistance.
I apologise, I would have attached a mini sheet but I am still trying to work out the installation issue since upgrading.
=SUMPRODUCT((MOD(ROW(S70:S333)-70,6)=0)*(J70:J333="CBD"),(S70:S333))
I need the formula to also include that it only SUM cells that have a positive figure.
Cheers,
Dave.