Return totals in a cell is blank, empty

W

Wings

Member
Joined
Feb 13, 2015
Messages
34
Reaction score
0
Points
6
Excel Version(s)
2013
Hello,
Can someone help me with a formula to return a total for a range of cells if they are empty. If the cell range includes empty cells, then I need to then go to another range of cells and get the total amounts for the cells that are empty.
 
Can you post a sample workbook showing the layout and some expected outcomes?
 
A
BC
£757.50
 won
£385.00
£8,659.5314.10.16won
£4,953.0017.10.16
£1,218.0014.10.16won
£5,984.0021.10.16Lost

£8,147.5825.10.16
AliGW
Can you see that? Under column C, I need to add up the values in column A that correspond to the blanks in C, the idea being the lower the total being better, as that would mean our records were straight even if the order was on hold or lost.
 
Excell Sheet

AliGW,
Maybe this is better?

Thanks for your help!
 

Attachments

  • Book2.xlsx
    9.7 KB · Views: 17
Arrrh that's better, i was on a similar track, but not quite there. Thanks very much.
 
You must log in or register to reply here.
Back
Top