Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif with a segmented range
Is there an easy way to do a countif with the data in question in every
second column? The function might look like =countif(A3,C3,E3,"RED") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif with a segmented range
=SUMPRODUCT(--(A3:A8="red"),MOD(ROW(A3:A8),2))
Counts every other row and if it is "red" -- Wag more, bark less "Allan" wrote: Is there an easy way to do a countif with the data in question in every second column? The function might look like =countif(A3,C3,E3,"RED") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif with a segmented range
The function might look like =countif(A3,C3,E3,"RED")
If the range is only a "few" cells: =(A3="red")+(C3="red")+(E3="red") If the range is more than a "few" cells: =SUMPRODUCT(--(MOD(COLUMN(A3:E3)-COLUMN(A3),2)=0),--(A3:E3="red")) -- Biff Microsoft Excel MVP "Allan" wrote in message ... Is there an easy way to do a countif with the data in question in every second column? The function might look like =countif(A3,C3,E3,"RED") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using countif with a name of a range | Excel Worksheet Functions | |||
Setting up segmented bar graphs | New Users to Excel | |||
Urgent help needed - floating segmented bar chart | Charts and Charting in Excel | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
does the =COUNTIF have to be a range? | Excel Worksheet Functions |