| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct formula (multiple criteria)
Hi,
I've got the sumproduct formula to work (thanks to you guys and girls) but now what i want to do is sum cells according to 2 criteria ... but i want both of those criteria to be this OR that OR something else. To put it another way, i want to sum the number of downloads (in column A) but only if column B contains either "France" OR "Italy" and column C contains either "Brand A" OR "Brand B" Many thanks Stuart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic range names, multiple criteria, sumproduct | Excel Discussion (Misc queries) | |||
| multiple criteria in if or sumproduct | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
| Countif formula with multiple criteria ie >30 and <60? | Excel Worksheet Functions | |||
Threaded Mode
