Thread
:
how to compare two columns and get a output from it
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
[email protected]
external usenet poster
Posts: 1
how to compare two columns and get a output from it
Scoops wrote:
wrote:
example
A1 A2
6.5.6 R200
6.5.6 R200
5.6 R100
here basically i have two column a1 and a2 and i want to count all R200
which has 6.5.6 how do i do this?
rajesh
Hi rajesh
I *think* you want to count the number of times that 6.5.6 is in the
same row as R200.
If so, try this:
=SUMPRODUCT((A3:A5="6.5.6")*(B3:B5="R200"))
Regards
Steve
Thanks steve, you gave perfect answer.
rajesh
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]