Forum Discussion

AlarmSpecialist's avatar
AlarmSpecialist
Copper Contributor
Jan 07, 2023

Using the IF function

I'm not very good with Excel, but I'm learning.  I have 2 tabs and I want to tell the 1st page that if  cell C3 on the 2nd page equals "A" then the amount entered in C2  needs added into cell C1 on the 1st page.  Does that make sense? 

  • Peyman_gholami's avatar
    Peyman_gholami
    Copper Contributor

    Hi, AlarmSpecialist
    I am not sure I understand your question, but if you want add C2 to C1 in the other Cell, You can use this Formula:
    =IF(Sheet2!C3="A",C1+C2,"")

    • AlarmSpecialist's avatar
      AlarmSpecialist
      Copper Contributor
      Page 1 - I want it to equal the totals from page 2.
      Page 2 - I want to enter dollar amounts in one cell, then a code (A, B, C) in another cell.
      Then, I want to add all the "A" codes on page 2 to one cell on page 1 as the total of all "A" amounts.
      • mathetes's avatar
        mathetes
        Silver Contributor

        AlarmSpecialist 

         

        Since you are learning Excel, you might want to become familiar with sites such as the one linked here (specifically in this case to the SUMIF function). You can learn a lot about functions and how they work here. YouTube also has many effective instructional videos, from quite basic to quite advanced.

Resources