| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding if formuals
How do i code this if formual?
=SUMIF(TOEPIEXP!F:F,"=1",TOEPIEXP!P:P) -- Message posted via http://www.officekb.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Coding if formuals
In VBA?
Msgbox Application.SUMIF(Worksheets("TOEPIEXP").Range("F: F"),1,Worksheets("TOEPIEXP").Range("P:P")) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "jln via OfficeKB.com" <u25956@uwe wrote in message news:6af34c0bdd926@uwe... How do i code this if formual? =SUMIF(TOEPIEXP!F:F,"=1",TOEPIEXP!P:P) -- Message posted via http://www.officekb.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Coding if formuals
How do i place this code in say cell D5?
Bob Phillips wrote: In VBA? Msgbox Application.SUMIF(Worksheets("TOEPIEXP").Range("F :F"),1,Worksheets("TOEPIEXP").Range("P:P")) How do i code this if formual? =SUMIF(TOEPIEXP!F:F,"=1",TOEPIEXP!P:P) -- Message posted via http://www.officekb.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Coding if formuals
It would be in VBA im trying to have the macro auto create a sheet.
Bob Phillips wrote: In VBA? Msgbox Application.SUMIF(Worksheets("TOEPIEXP").Range("F :F"),1,Worksheets("TOEPIEXP").Range("P:P")) How do i code this if formual? =SUMIF(TOEPIEXP!F:F,"=1",TOEPIEXP!P:P) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Coding if formuals
It would be in VBA im trying to have the macro auto create a sheet.
Bob Phillips wrote: In VBA? Msgbox Application.SUMIF(Worksheets("TOEPIEXP").Range("F :F"),1,Worksheets("TOEPIEXP").Range("P:P")) How do i code this if formual? =SUMIF(TOEPIEXP!F:F,"=1",TOEPIEXP!P:P) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excels formuals | Excel Discussion (Misc queries) | |||
| Formuals | Excel Discussion (Misc queries) | |||
| New to Formuals | Excel Worksheet Functions | |||
| Need to place 3 formuals in VBA | Excel Programming | |||
| IF, Then formuals | Excel Programming | |||
Linear Mode
