Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif using or
Data that looks like this
Account May June July ... 1 $10 $15 $22 ... 2 $12 $8 $34... .... Each account number is distinct (no duplicates) I want a forumula to give me the sum of certain accounts for may. I can use sumif(a2:a200,1,b2:b200)+sumif(a2:a200,2,b2:b200) to get totals of account 1 and 2 for may but what if I wanted to sum 10 accounts for may that would be a really big formula... there must be a better way. Something like sumif(a2:a200,or(1,2,3,4,etc),b2:b200) which excel doesnt allow. Seems to me that vlookup with an array would work but I cant get it to sum the results. Thanks for any help Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |