Gerry Hunt
New Member
- Joined
- Apr 10, 2021
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
I need a formula to examine Column “O” in my spreadsheet for the criteria “Apr-21” and then to enter an adjacent, related Column “J” and add up the monetary value for each instance of Apr-21 in Column “O” thereby providing a total value for Apr-21 in another cell – lets call it “INCOME C4”. I have used the following to no avail:
=SUMIF(CONSULTATIONS!O4:O200,"=Apr-21",CONSULTATIONS!J4:J200) but it just provides a monetary value figure for the first instance of Apr-21 in Column O.
If you can help - THANK YOU - so far Defeated.
=SUMIF(CONSULTATIONS!O4:O200,"=Apr-21",CONSULTATIONS!J4:J200) but it just provides a monetary value figure for the first instance of Apr-21 in Column O.
If you can help - THANK YOU - so far Defeated.