LinkBack URL
About LinkBacks
windme 
Try this:
=SUM(COUNTIF(INDIRECT({"A1:D1","A3:D3"}),4))
IF you count every odd rows then try this:
=SUMPRODUCT((MOD(ROW(A1:D100),2)=1)*(A1:D100=4))
Try this:
=SUM(COUNTIF(INDIRECT({"A1:D1","A3:D3"}),4))
IF you count every odd rows then try this:
=SUMPRODUCT((MOD(ROW(A1:D100),2)=1)*(A1:D100=4))
Last edited by Teethless mama; 02-17-2008 at 03:05 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks