Microsoft Excel
Closed
jms31280
-
1 Jul 2011 à 09:58
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Jul 2011 à 09:04
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Jul 2011 à 09:04
Related:
- Microsoft Excel
- Microsoft excel mod apk - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
2 Jul 2011 à 09:04
2 Jul 2011 à 09:04
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