Dear all pro's,
I'm just a new here. Hope anyone can help. I tried to search everywhere in the internet but i could not find the exact answer i wanted to.
Cherrs
Dear all pro's,
I'm just a new here. Hope anyone can help. I tried to search everywhere in the internet but i could not find the exact answer i wanted to.
Cherrs
=sumproduct((A1:A100="x")*(B1:B100="y"))
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
doesnt work. Okay, here is my actual problem.
ColumnA ColumnB
1 P
1 L
2 P
3 L
2 L
1 P
I wanted the excel to count number "1" in column A if only the ColumnB =P. The answer should be =2
How is this possible and what formula to use? Please advice. Thanks.
=sumproduct((A1:A100=1)*(B1:B100="p"))
You can use this function:
Note : change the red one for value in column A, change the blue for value in column BPlease Login or Register to view this content.
Click (*) if you received helpful response.
Regards,
David
Hi mugies
May be: =SUMPRODUCT(--(A1:A6=1),--(B1:B6="P")) extend ranges to suit.
@ SDCh The OP's profile is Excel 2003. the COUNTIFS is not available in that version.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
@Kevin UK : Yes, you right, sorry not see the excel version that OP's use.
You can also use 'countif' or use a pivot table.
Hi all,
Got it. Thanks popipipo.
popipipo Re: Counting x in Column A if Column B equals to y
=sumproduct((A1:A100=1)*(B1:B100="p"))
This formula works for me. Now im trying if third condition works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks