LinkBack URL
About LinkBacks
I want to add all those values over a number of rows in column A that have the word 'inactive' against them in column B. Can someone provide the formula please. When I looked up SumX and tried to apply it it would not work.
Many thanks
Dominique
I want to add all those values over a number of rows in column A that have the word 'inactive' against them in column B. Can someone provide the formula please. When I looked up SumX and tried to apply it it would not work.
Many thanks
Dominique
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. Try this
=SUMIF(B:B,"Inactive",A:A)
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
Many thanks to you both, will now go off and apply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks