Microsoft Excel
Closed
jms31280
-
Jul 1, 2011 at 09:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 2, 2011 at 09:04 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 2, 2011 at 09:04 AM
Related:
- Microsoft Excel
- Microsoft excel download - Download - Spreadsheets
- Excel marksheet - Guide
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel date format dd.mm.yyyy - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 2, 2011 at 09:04 AM
Jul 2, 2011 at 09:04 AM
One way would be to use in third column
=IF(A1=B1,1,0)
and then you add the total at the end
other way can be to use SUMPRODUCT
=SUMPRODUCT(((A1:A4)=(B1:B4)) *1)
I am sure there are other ways too
=IF(A1=B1,1,0)
and then you add the total at the end
other way can be to use SUMPRODUCT
=SUMPRODUCT(((A1:A4)=(B1:B4)) *1)
I am sure there are other ways too