If function help needed

Berandon

New Member
Joined
Sep 8, 2014
Messages
29
Is it Possible to have an If function run the whole column of "D" that If there is a "1" in the box, it adds a different column but the same row to a box. eg ... If D9-D2000 equals "1" then add M(same Row) to M4 and O(same row) to O4 and P(same Row) to O5.

I guess i could do a different If function for each cell, but I was hoping to consolidate it into 1 cell.
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Comfy

Well-known Member
Joined
Dec 21, 2009
Messages
3,377
There is a function called SUMIF.

So M4 would be:

=SUMIF(D9:D2000,1,M9:M2000)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,325
Messages
5,547,263
Members
410,783
Latest member
sonnny
Top