• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

count the number of RED BLUE color numbers entered in different cells

V

vishalvijayan

New Member
Hello, I have an excel sheet with 4 columns and 4 rows. Each cell in it contains numbers. Some are in RED color and some in BLUE color. Is there a way using =countif() to count the number of cells with RED color and number of cells with BLUE color.


IN H WO 1325 1354 1353 1258 1114 0944

OUT 2308 2352 2321 2350 2144 1724

W.H. 0943 0958 0928 1052 1030 0740


Please guide.


Regards

Vishal
 
Sir, could you check this link please.


This might help you. (This is by Luke sir, not me, I just searched it).


http://chandoo.org/forums/topic/sum-based-on-various-colours-1
 
You must log in or register to reply here.
Back
Top