| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
I have been trying to create a sumproduct formula for a excel sheet,
which has multiple criterias and data ranges. for example: - first range is D12:P16 with this criteria =4 second range is D21:P22 with this criteria =4 third range is D28:P34 with this criteria =3 fourth range is D23:P23 with this criteria =3 anyone that can help me with this? many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif and multiple ranges | Excel Discussion (Misc queries) | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| sumproduct with multiple tab ranges | Excel Worksheet Functions | |||
| countif for multiple ranges and criteria | Excel Discussion (Misc queries) | |||
| countif help for multiple criterias | Excel Worksheet Functions | |||
Threaded Mode
