| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help needed to add values with conditions
Hi,
I have some data N O P Q TD (Y/N) Value VAT Total Val Y £71.44 £10.72 £82.16 4 N £71.44 £10.72 £82.16 5 N £84.08 £12.61 £96.69 6 Y £84.08 £12.61 £96.69 N £102.85 £15.43 £118.28 N £34.22 £5.13 £39.35 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £84.08 £12.61 £96.69 N £84.08 £12.61 £96.69 Y £84.08 £12.61 £96.69 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 N £0.00 £0.00 £0.00 44 0 £700.35 £105.05 £805.40 46 Recharges 48 What I need is a formula to add up the values in Q4:Q44 but only if the corresponding value in the N column is Y. Every formula ive tried always seems to come back with an error. Thanks in advance. Alex |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Needed : Sum on Conditions | Excel Discussion (Misc queries) | |||
| Sumproduct with conditions - urgent help needed | Excel Worksheet Functions | |||
| Date Formula with 2 conditions met needed | Excel Discussion (Misc queries) | |||
| Two conditions in one cell. Help needed ASAP | Excel Discussion (Misc queries) | |||
| 2 conditions needed to check and count of items based on that | Excel Worksheet Functions | |||
Threaded Mode
