I am a bit of a newbie to excel. I am trying to use the Countif function, but where I am specifying the range, I want to start in a fixed cell, for example A2, and continue to count in column A until a number, X, which is calculated by adding up the values in other cells, so it will change.
Is there a way to do this? Thanks!
Hi and welcome to the forum
Im having a hard time visualising what you are trying to do, but maybe take a look at using a helper column to add the values, and then use countifS() to include that halper column?
If that doesnt work for you, I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I don't think I explained it very well. So, I have some data that I am exporting from another program into excel (its survey responses). I have 5 columns, and 300 rows. Each row can have text in none, one, two, three, four or all five columns. I want to count the non-blank cells in each column BUT I want to use countifs, so that if one cell in one row is populated, i want to check if the other 4 cells in that row are populated or not. If they are not populated, ie there is only 1 cell populated in a certain row, then I want to record this, these are the ones I want to count. Does this make sense?! I am trying to use this: =countifs(A1:A300,"Something",B1:B300,"",C1:C300,"",D1:D300,"",E1:E300,""). I am hoping this will count the number of non-bank cells in column A where the corresponding cells in columns B-E are ALL blank. But it doesn't work! Any ideas?!
Yep; i agree with FDibbins,
Why not just post an excel file, without confidentional information.
Also add the desired (expected) result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
try
=countifs(A1:A300,"<>",B1:B300,"=",C1:C300,"=",D1:D300,"=",E1:E300,"=")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks. That doesn't work! I should have mentioned I am using Excel 2008 on a mac, does this make a difference?
Thank you!
Oh, I"ve done something now and it works! Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks