Count if for every other row

spottkitty

Posts: n/a

Count if for every other row

I have this formula that adds every other column in my sheet.

=SUM(AH16,AJ16,AL16,AN16,AP16,AR16,AT16,AV16,AV17, AX16,AZ16)

I'm trying to countif the columns next to these that are 1 or greater. the
ways I've tried the formula return errors.

Any insight would be appreciated!

Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Intervals of 1 Numeric value in a Row and Return Count down Column	Sam via OfficeKB.com	Excel Worksheet Functions	8	October 4th 05 04:37 PM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	8	May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	0	May 15th 05 08:14 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
SUMPRODUCT Formula to Count Row of data Below Matched Criteria	Sam via OfficeKB.com	Excel Worksheet Functions	8	February 3rd 05 01:37 AM

All times are GMT +1. The time now is 12:10 PM.

Menu

About Us