I know how to use countif formulas but I can't get it to work when the columns I need to count are spread out.
I need to count how many times a cell has a value greater than 0. Problem is it's not in consecutive columns like Columns B through F.
It's trying to count columns greater than 0 in Columns, B, D, E, G.
Last edited by Statz; 03-02-2022 at 12:34 PM.
a couple of ways
=SUM(COUNTIF(INDIRECT({“B1:B100″,”D1:D100″,”E1:E100″,"G1:G100"}),”>80″))
OR
=COUNTIF(A1:B100, ">0") + COUNTIF(D1:D100,">0")+ COUNTIF(E1:E100,">0")+COUNTIF(G1:G100,">0")
Change the range to meet your actual need
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
cant edit
should be
=SUM(COUNTIF(INDIRECT({"B1:B100","D1:D100","E1:E100","G1:G100"}),">0"))
Thank you I got it!
Next time, please refresh your memory regarding the forum rule about thread titles - this one is generic and does not tell us what you are trying to do. More care in future, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks