How do i code this if formual?

=SUMIF(TOEPIEXP!F:F,"=1",TOEPIEXP!P:P)

--
Message posted via http://www.officekb.com

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
>

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

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

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