Please_H
Board Regular
- Joined
- Apr 16, 2017
- Messages
- 181
- Office Version
- 2019
- Platform
- Windows
- Mobile
Hello !
I am trying to get an equation fixed but I can't, lol...
The working equation :
=SUMPRODUCT((MONTH(Ledgers!$D$61:$D$80)=D211)*Ledgers!$I$61:$I$80)
What I want to get done,
I need the equation to technically do the above but to pull Number 61 & 211 from 2 cells in the sheet this equation really is.
Is this possible?
Tried using Concatanate and refer cells but the equation is not identified
Can someone please help me out? Because there are huge batches unless I would end up editing
Thank you so much
I am trying to get an equation fixed but I can't, lol...
The working equation :
=SUMPRODUCT((MONTH(Ledgers!$D$61:$D$80)=D211)*Ledgers!$I$61:$I$80)
What I want to get done,
I need the equation to technically do the above but to pull Number 61 & 211 from 2 cells in the sheet this equation really is.
Is this possible?
Tried using Concatanate and refer cells but the equation is not identified
Can someone please help me out? Because there are huge batches unless I would end up editing
Thank you so much