formula help
 

I am trying to set up a formula that would search cells in a column for
specific text (a range of general ledger codes). If the text is found, I need
it to trigger a calulation of cells in the specfic row in order to determine
the grand total for the spreadsheet.

For example, for every row in column B, if the text 1021-10 is found,
subtract column G from column F in order to provide the grand total for
1021-10. If the formula could be set up to search for multiple general ledger
codes i.e. 1021-10, 1021-12, etc. to provide a cumulative total,that would be
even better.

Thanks!

formula help
 

=SUMIF(B:B,"1021-10",F:F)-SUMIF(B:B,"1021-10",G:G)

Vaya con Dios,
Chuck, CABGx3



"MJ" wrote:

I am trying to set up a formula that would search cells in a column for
specific text (a range of general ledger codes). If the text is found, I need
it to trigger a calulation of cells in the specfic row in order to determine
the grand total for the spreadsheet.

For example, for every row in column B, if the text 1021-10 is found,
subtract column G from column F in order to provide the grand total for
1021-10. If the formula could be set up to search for multiple general ledger
codes i.e. 1021-10, 1021-12, etc. to provide a cumulative total,that would be
even better.

Thanks!