Update total based on two columns
 

The cells in column C have either BP or SIA in them. In column J there is a
dollar amount. Every day I add data to columns C and J. I have a total for
SIA in cell N2 and a total for BP in cell N3. I need a formula to put into
cell N2 to sum all the values in column J if the corresponding cell in column
C has SIA in it. Also, cell N3 to sum all the values in column J if the
corresponding cell in column C has BP in it. Let me know if you don't
understand my question. Thank you.

Update total based on two columns
 

In N2
=SUMIF(C:C,"SIA",J:J)

In N3
=SUMIF(C:C,"BP",J:J)


If this post helps click Yes
---------------
Jacob Skaria


"Jambruins" wrote:

The cells in column C have either BP or SIA in them. In column J there is a
dollar amount. Every day I add data to columns C and J. I have a total for
SIA in cell N2 and a total for BP in cell N3. I need a formula to put into
cell N2 to sum all the values in column J if the corresponding cell in column
C has SIA in it. Also, cell N3 to sum all the values in column J if the
corresponding cell in column C has BP in it. Let me know if you don't
understand my question. Thank you.

Update total based on two columns
 

perfect, thank you.

"Jacob Skaria" wrote:

In N2
=SUMIF(C:C,"SIA",J:J)

In N3
=SUMIF(C:C,"BP",J:J)


If this post helps click Yes
---------------
Jacob Skaria


"Jambruins" wrote:

The cells in column C have either BP or SIA in them. In column J there is a
dollar amount. Every day I add data to columns C and J. I have a total for
SIA in cell N2 and a total for BP in cell N3. I need a formula to put into
cell N2 to sum all the values in column J if the corresponding cell in column
C has SIA in it. Also, cell N3 to sum all the values in column J if the
corresponding cell in column C has BP in it. Let me know if you don't
understand my question. Thank you.