I have the following formula which works fine to total the numbers in each alternate column for a row - =SUMPRODUCT(--(MOD(COLUMN(G7:OO7)-COLUMN(G7),2)=0),G7:OO7)
What I need to do is the same but just count how many cells contain data within the same range as the above formula - so counting alternate columns e.g. G7, I7, K7, M7 e.t.c
Is this possible? and is there such a thing as COUNTPRODUCT?
Any help much appreciated
Thanks
Try:
=SUMPRODUCT(--(MOD(COLUMN(G7:OO7)-COLUMN(G7),2)=0))
Quang PT
May be this......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
=SUMPRODUCT(--(MOD(COLUMN(G7:OO7)-COLUMN(G7),2)=0),--(G7:OO7<>"")) worked a treat.
Thanks a lot for your help
Glad to help you. Thanks for the feedback.
If you have got the solution, please mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks