| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif - with 2 conditions - rows and columns
Hi
SUMIF(Jan!$BY$3:$DL$3,Projects!$C6,Jan!$BZ$263:$BZ $266) this formula seems to work but only returns the number from BZ263 not the sum of the whole range. As you see it does access 2 sheets and the first criteria is across columns the 2nd down a list of rows. Suggests??? Cheers UKMAN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF-with 2 conditions, need to add range in 2 columns | Excel Worksheet Functions | |||
| Counting rows that meet conditions in multiple columns | Excel Worksheet Functions | |||
| Sumif w/ 2 conditions in in different rows | Excel Worksheet Functions | |||
| SumIF full columns, multiple conditions | Excel Discussion (Misc queries) | |||
| sumif columns and rows | Excel Worksheet Functions | |||
Threaded Mode
