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

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

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

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

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