LinkBack URL
About LinkBacks
Hello
I have a table with text in A2:A7 and numbers in B2:B7. I'd like count the numbers matching only to certain text in A9 i.e Excel matching text in A2 and A4 then counting the 2 numbers in B2 and B4 into cell B9 totalling 19
Can you help please
Hello
I have a table with text in A2:A7 and numbers in B2:B7. I'd like count the numbers matching only to certain text in A9 i.e Excel matching text in A2 and A4 then counting the 2 numbers in B2 and B4 into cell B9 totalling 19
Can you help please
Did you tried the SUMIF function? In B9 and copy down.
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi Fotis1991
I've tried sumifs but it's odd as it doesn't want to work. The total still shows as 0
Put this formula in column B9,B10 & B11.
=SUMIFS(B2:B7,A2:A7,"word")
=SUMIFS(B2:B7,A2:A7,"Excel")
=SUMIFS(B2:B7,A2:A7,"Powerpoint")
It does work. In Cell A9, there is a trailing space after the d of "word". Delete it.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
...........................
Try: SUMPRODUCT(($A$2:$A$7=A9)*($B$2:$B$7)) and drag down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks