-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sum(if
-
S
This seemingly basic task is making me pull my hair out...
I'm using =SUM(IF( as an array to count the number of rows that meet multiple conditions. The data is based in an external workbook, so I'm stuck with SUM(IF. When adding a condition to my formula that looks in a particular column for cells containing '0' (zero), things start falling apart...- Satele
- Thread
- array excel sum sum(if zero values
- Replies: 3
- Forum: Excel Questions
-
E
adding Indirect formula to my current sum if array formula
I’ve never used the "Indirect" formula before and I’m struggling to write this into my current formula. I have an “Sum(If(“ array formula and I’m trying to make it more dynamic by having the formula select the correct tab (Tabs are labeled by Day of the week) to pull the data from. I have a cell...- Eastbay2
- Thread
- array formula indirect sum(if sumif
- Replies: 4
- Forum: Excel Questions
-
Sum IF Match
I have similar data in column A and in Column D, I want to match the two column and sum the values of corresponding column B. I need a formula. Thanks Sohail- srizki
- Thread
- sum(if
- Replies: 18
- Forum: Excel Questions
-
Sumproduct or sum(if( etc.
I have sites names in column A, there are two sites and employees names in column B, some employees may be working on both sides, I need to create a table that shows total of each site per employees. So the formula should work like, sum of hours in column F if site is abc and employee is def...- srizki
- Thread
- sum(if sumproduct
- Replies: 2
- Forum: Excel Questions
