| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula
I'm not sure how to explain this!
I need a total of the number of times that "G" (no quotes) appears in the range S4:S1516, based on "Ou" (no quotes) appearing in the same row, in the range J4:J1516. Many thanks Rendon |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula
=SUMPRODUCT(--(S4:S1516="G"),--(J4:J1516="Ou"))
-- Gary''s Student - gsnu2007a |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula
Superb!!
Rendon "Gary''s Student" wrote in message ... =SUMPRODUCT(--(S4:S1516="G"),--(J4:J1516="Ou")) -- Gary''s Student - gsnu2007a |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
