Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 sp3 problem | Excel Discussion (Misc queries) | |||
Exel 2003 Copy Formula Problem | Excel Worksheet Functions | |||
Copy and paste problem Excel 2003 to Word 2003 | Excel Discussion (Misc queries) | |||
Problem copying a formula in Excel 2003 | Excel Discussion (Misc queries) | |||
EXCEL 2003 PROBLEM | Excel Worksheet Functions |