iamanexcelnoob
Board Regular
- Joined
- Jun 15, 2016
- Messages
- 71
hey all.
quick and probably easy (for you guys) question.
i have a data pull on one tab and an analysis tab on another.
i want to extract said data by honing in on two specific criteria, located in Column A and Column B - and denoted as such in my analysis tab and summing the resulting 3 columns (D,E,F) if the conditions are met.
i'm sure there is a way with SUMIFS, but i just keep getting #VALUE! messages.
thanks!
quick and probably easy (for you guys) question.
i have a data pull on one tab and an analysis tab on another.
i want to extract said data by honing in on two specific criteria, located in Column A and Column B - and denoted as such in my analysis tab and summing the resulting 3 columns (D,E,F) if the conditions are met.
i'm sure there is a way with SUMIFS, but i just keep getting #VALUE! messages.
thanks!