Formula problems!!!!

  • Thread starter Thread starter Bernard Liengme
  • Start date Start date
B

Bernard Liengme

Hello LD,
=SUMPRODUCT( (A1:A100="A")*(B1:B100="W)*1)

or make the equivalent to a pivot table:
In E1, F1 enter W and I
In E2, E3, E4 enter A, B, C
In F2 =SUMPRODUCT( (A1:A100=$E2)*(B1:B100=F$1)*1) and copy across and down.

Best wishes
Bernard
 
Yes but without the *1 bit.

Bernard Liengme said:
Hello LD,
=SUMPRODUCT( (A1:A100="A")*(B1:B100="W)*1)

or make the equivalent to a pivot table:
In E1, F1 enter W and I
In E2, E3, E4 enter A, B, C
In F2 =SUMPRODUCT( (A1:A100=$E2)*(B1:B100=F$1)*1) and copy across and down.

Best wishes
Bernard
Click to expand...
 
Agreed, the 1 bit is not essential but one gets used to using it to convert
Boolean values to 1s and 0s.
Bernard
 
My point.exactly, or at least implicitly.

Bob

Harlan Grove said:
...
..

-- (and I mean that in the C sense.)

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.
Click to expand...
 
I have job levels in column A. ex. A,B,C, etc.
In column B I have race. ex. W(White), I(Indian), etc.

I need a formula to count all the Job levels per race.
ex. B(White)=15, B(Indian)=5, etc.
I dont want to use a pivot table.

Please help.
 
Back
Top