Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to use a sumif-like formula that totals like a sumif, but have
multiple lookups like a sumproduct. The formula would lookup a persons name AND a date entered another field that is used as the filter, within a list of names, dates, and column values. I tried this but it didn't work: SUMIF('Raw Data'!$B$2:$B$200,--('Chart Data'!$F$4,--('Chart Data'!$B$12)),'Raw Data'!E$2:E$200) Let me know if you need clarification Thanks in advance -- Chris Freeman IT Project Coordinator |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How to lookup multiple values and summing them up in one cell | Excel Worksheet Functions | |||
Multiple lookup value's | Excel Worksheet Functions | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions |