Count a Column only when the Row is Not Marke
Closed
Jason
-
May 18, 2009 at 06:20 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 19, 2009 at 02:31 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 19, 2009 at 02:31 AM
Related:
- Count a Column only when the Row is Not Marke
- Saints row 2 cheats - Guide
- How to type a check mark on mac - Guide
- Display two columns in data validation list but return only one - Guide
- How to delete row in word - Guide
- Vba find column by name ✓ - Excel Forum
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
May 19, 2009 at 02:31 AM
May 19, 2009 at 02:31 AM
Suppose for marking purpose we are using character 1 then use below formula ....
=SUMPRODUCT(--(A1:A3=1),--(F1:F3<>1))
Array formula will also work but don't forget to press Control + Shift + enter === {} brackets will appear after pressing Control + Shift + enter
=SUM(IF(A1:A3=1,1,0)*(IF(F1:F3<>1,1,0)))
Don't hesitate to contact me again if you have any query
=SUMPRODUCT(--(A1:A3=1),--(F1:F3<>1))
Array formula will also work but don't forget to press Control + Shift + enter === {} brackets will appear after pressing Control + Shift + enter
=SUM(IF(A1:A3=1,1,0)*(IF(F1:F3<>1,1,0)))
Don't hesitate to contact me again if you have any query
