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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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,663
Messages
5,549,290
Members
410,908
Latest member
Allen P
Top