| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct CountIF issue
I am trying to count the number of times the value "F" appears in column G,
if the value "HCSO" appears on the same row in column J. And I need it to calculate across 31 worksheets. I tried this but it returns the total number of times "F" appears. Any Ideas? =SUMPRODUCT(SUMIF(INDIRECT("'7-"&ROW(INDIRECT("1:31"))&"'!J:J"),"=HCSO"))--SUMPRODUCT(COUNTIF(INDIRECT("'7-"&ROW(INDIRECT("1:31"))&"'!G:G"),"=F")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup and sumproduct combine issue | Excel Worksheet Functions | |||
| Issue with SUMPRODUCT leaving a 0 value in cell | Excel Worksheet Functions | |||
| Sumproduct #N/A! error issue | Excel Worksheet Functions | |||
| Issue with sumproduct | Excel Worksheet Functions | |||
| SUMPRODUCT issue | Excel Worksheet Functions | |||
Threaded Mode
