IF statement with matched results

KirstAnn

New Member
Joined
Jan 23, 2018
Messages
2
So I think I need an if statement but I cannot seem to make it work but here is my problem (hopefully I can explain it well enough)

Colum A is a number (meters squared of work completed)
Colum B is size of rock used (naming convention used through drop down box being used a total of 5 variables)
Colum C is size of rock used (sometimes more than one size is used again with same naming conventions but never are there 2 cells with the same rock repeated)

In Colum D I want to total the amount of square meters a particular rock sized has been used.

So along the lines of for cell D1 I’m trying to solve IF B1=ROCK7 then D1=A1, if no result matched check cell C1 for ROCK7, if matched then D1=A1, if no result in B1 or C1 then leave blank

Thanks in advance
 

Forum statistics

Threads
1,082,500
Messages
5,365,935
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top