Claudio0136
New Member
- Joined
- Oct 16, 2011
- Messages
- 2
I would like to know a formula where I can add cells Sheet1(B3)+Sheet2(B3), but only add the ones that have the month of "JAN" on Sheet1(A3) and Sheet2(A3), and ignores the deposits for other months…so that Sheet1(C4)=$50.00
-- removed inline image ---
Thanks in advance!
**Sheet1(A3)=FEB, Sheet1(B3)=$0.00...and
Sheet2(A3)=JAN, Sheet2(B3)=$50.00...
Sheet1(C4)=Total (Sheet1 & 2) January deposits
**I was trying to post with an image of what I am trying to do using paint but no luck.
-- removed inline image ---
Thanks in advance!
**Sheet1(A3)=FEB, Sheet1(B3)=$0.00...and
Sheet2(A3)=JAN, Sheet2(B3)=$50.00...
Sheet1(C4)=Total (Sheet1 & 2) January deposits
**I was trying to post with an image of what I am trying to do using paint but no luck.
Last edited: