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 mod apk for windows 11 - Download - Spreadsheets
 - Kernel for excel repair - Download - Backup and recovery
 - Vat calculation excel - Guide
 - Menu déroulant excel - Guide
 - Excel online macros - 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