I need help please. I have a table Let's say Store number in column A, States in column B, Sales in column C, and I am trying to create a formula that will count the number of stores by States if Sales are greater than 0. I have tried a combination of countif and if, and countifs withouth success. Any help would be appreciated.
=COUNTIFS(A:A, "Store A", B:B, "VT", C:C, ">0")
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
if state name is "AA" or refer cell
=COUNTIFS(C1:C10,">0",B1:B10,"AA")
☚ Click ★ just below left if it helps, Boo?ath?
@Chemist, I could not get it to work but Boopa's formula worked fine.
Thanks to both of you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks