| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT assistance
I am trying to count the number of occurences where Column F has a value =43
and the corresponding row in Column J has the word AGIMO. I have the following but it doesn't seem to return a value. Am i on the right track??? =SUMPRODUCT(('Gazettals 06-07'!F2:F1399=43),(J2:J1399="AGIMO")) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMPRODUCT assistance
Try:
=SUMPRODUCT(--('Gazettals 06-07'!F2:F1399=43),--(J2:J1399="AGIMO")) See http://www.mcgimpsey.com/excel/doubleneg.html In article , SDH wrote: I am trying to count the number of occurences where Column F has a value =43 and the corresponding row in Column J has the word AGIMO. I have the following but it doesn't seem to return a value. Am i on the right track??? =SUMPRODUCT(('Gazettals 06-07'!F2:F1399=43),(J2:J1399="AGIMO")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct assistance - need multiple ANDs and ORs | Excel Worksheet Functions | |||
| Sumproduct assistance | Excel Worksheet Functions | |||
| SUMPRODUCT Assistance | Excel Worksheet Functions | |||
| Assistance please? | Excel Worksheet Functions | |||
| Need some assistance | Charts and Charting in Excel | |||
Linear Mode
