Thread: Calculate number of "A" in particular cells

Hi All,

I have one excel sheet with columns from A to LZ and number of rows.
Each column have only letter (one of A,B,C,D,E). This if for weekly table:

COLUMN define: Mon-Sun
ROWS define: work type (A B C or D)

For example;
COLUMNS: Su-Mo-Tu-We-Th-Fr-Sa-Su-Mo-......
ROWS: A -A - B - B - B - B - B -C - C - ......till column LZ.

Issue:
I want a formula for any row, from which, I can calculate (for that particular row) number of B's on Mo-Tu right from column A till LZ.

Appreciate you help..

Didnt get the structure of ur table... can u post a sample

Hi Mohit..

I copied few cells from two rows and pasted below:
-----------------------------------------------------
Fri Sat Sun Mon Tue Wed Thu Fri Sat
A B B B D D B A C <<
-----------------------------------------------------
So the last (where I have marked <<) I want to use a formula that will calculate, say, number of A's present under Fri in one row. (here answer should be two).

Logic might be...
Checking for alphabet under "Fri"...if it is "A", count=count + 1...something of that sort.

Hope I am clear this time.

Sorry for the format error...I have attached one row sample.
Let me know if you require more clarification.

Thanks a lot Teylyn..

This is precisely what I was looking for

Hey,
Sorry i couldnt get back to u earlier and even though u have the solution to ur problem, mebbe u cud use this simpler looking formula... :P

=SUMPRODUCT((A1:R1="Tue")*(A2:R2="B"))

Even this formula will work...

Regards
Mohit