Excel 2003 formula problem
 

I am trying to locate whenever 2 specific numbers are entered into column A &
B, when these numbers are entered, an amount is also entered in the same row
(in column H).
What I'm tring to do is delete that amount in coloum H from a total value at
the bottom of the spreadsheet. Therefore decreasing this total value
everytime an amount is place in column H where these specific numbers in
columns A&B stand in the same row.

My word, I hope this makes sense!

Excel 2003 formula problem
 

You can use sumproduct

=Sumproduct(--(A1:A100<24),--(B1:B100< 34),H1:H100)





"Lucinda" wrote:

I am trying to locate whenever 2 specific numbers are entered into column A &
B, when these numbers are entered, an amount is also entered in the same row
(in column H).
What I'm tring to do is delete that amount in coloum H from a total value at
the bottom of the spreadsheet. Therefore decreasing this total value
everytime an amount is place in column H where these specific numbers in
columns A&B stand in the same row.

My word, I hope this makes sense!