G
Guest
Hi,
I'm a bit if a newbie....
How can I sum only those cells that match 2 criteria (the company name cell
on the left of the $ figure to be added must = a reference cell AND the date
cell on the right must be blank)
This is a simple(?) spreadsheet that allows me to select a specific customer
and shows me the outstanding debt (ie the date cell is empty because they
didnt pay on x date)
I'm a bit if a newbie....
How can I sum only those cells that match 2 criteria (the company name cell
on the left of the $ figure to be added must = a reference cell AND the date
cell on the right must be blank)
This is a simple(?) spreadsheet that allows me to select a specific customer
and shows me the outstanding debt (ie the date cell is empty because they
didnt pay on x date)