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