| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Error
Im trying to create a formula and Im having a little problem getting it to
work correctly. Heres the formula: =COUNTIF(G4:G197,"Y")+(F4:F197)-500 If anything in G4:G197 = Y I want it to add the numbers from (F4:F197) and subtract it from 500 G5____F5________G6______F6______G7______F7 Y_____$50________ Y _____$100_______ N _____$200 Total $150-$500 =$350 Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Error
=500-SUMIF(G4:G197,"Y",F4:F197), or if you want a negative result (using your
example) =SUMIF(G4:G197,"Y",F4:F197)-500 "Killer" wrote: Im trying to create a formula and Im having a little problem getting it to work correctly. Heres the formula: =COUNTIF(G4:G197,"Y")+(F4:F197)-500 If anything in G4:G197 = Y I want it to add the numbers from (F4:F197) and subtract it from 500 G5____F5________G6______F6______G7______F7 Y_____$50________ Y _____$100_______ N _____$200 Total $150-$500 =$350 Any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Error
Thank you very that worked perfected your a lifesaver
"kassie" wrote: =500-SUMIF(G4:G197,"Y",F4:F197), or if you want a negative result (using your example) =SUMIF(G4:G197,"Y",F4:F197)-500 "Killer" wrote: Im trying to create a formula and Im having a little problem getting it to work correctly. Heres the formula: =COUNTIF(G4:G197,"Y")+(F4:F197)-500 If anything in G4:G197 = Y I want it to add the numbers from (F4:F197) and subtract it from 500 G5____F5________G6______F6______G7______F7 Y_____$50________ Y _____$100_______ N _____$200 Total $150-$500 =$350 Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Formula Error | New Users to Excel | |||
| Formula Recalculation Error | Excel Worksheet Functions | |||
| Let me save/close EXCEL if a formula I put in has an error in it | Setting up and Configuration of Excel | |||
| I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
Linear Mode
