Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counif with different cells, not a range
How can I count all the the 'zeros' from different cells such as A1, D1, G1, H1
TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counif with different cells, not a range
Try this
=SUMPRODUCT(--(COUNTIF(OFFSET(1:1,0,{0,3,6,7},1,1),0))) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Anthony Slater" wrote in message ... How can I count all the the 'zeros' from different cells such as A1, D1, G1, H1 TIA |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counif with different cells, not a range
Thanks Bob
That worked a treat... Have a good Christmas "Bob Phillips" wrote: Try this =SUMPRODUCT(--(COUNTIF(OFFSET(1:1,0,{0,3,6,7},1,1),0))) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Anthony Slater" wrote in message ... How can I count all the the 'zeros' from different cells such as A1, D1, G1, H1 TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |