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!
|