[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Coding if formuals

jln via OfficeKB.com

12/18/2006 3:38:00 PM

How do i code this if formual?

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

--
Message posted via http://www.of...
4 Answers

Bob Phillips

12/18/2006 3:51:00 PM

0

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.of...
>


jln via OfficeKB.com

12/18/2006 4:07:00 PM

0

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.of...

jln via OfficeKB.com

12/18/2006 4:09:00 PM

0

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.aspx/excel-programmin...

jln via OfficeKB.com

12/18/2006 4:09:00 PM

0

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.aspx/excel-programmin...