Google Sheets: If cell has any value, print this...

How would I write a formula for:

If cell G3 has any value in it, while H3 remains empty, then print the sum of all the previous values of column F.
However, if cell H3 also has a value in it, then print the sum of all the previous values of column E.

How would I write this formula is cell I3 ?

Thanks,
(See attachment)

JH

Not sure what you mean by "print", but if you mean "show in cell", try this...
=if(and(isvalue(G3),H3=""),sum(F:F),sum(E:E))

Great, thanks.
Do you know of a formula which will work in Google Sheets.
It doesn't recognise "isvalue"

JH

1. If a query is for Google Sheets, you should (a) say so at the outset and (b) post in the correcty section (I will move this to the Other Platforms section).
2. Please add Google Sheets to your forum profile where it says MS Office Version.

Thanks,

Any idea how to do this on Google Sheets?

JH

here is new formula that follows the conditions as written in your request:

Please Login or Register  to view this content.

Originally Posted by janmorris

here is new formula that follows the conditions as written in your request:

Please Login or Register  to view this content.

I used ISVALUE (which I understand doesnt work in Sheets) because G3<>"" will not catch any text entries in that cell. If there is no chance of entering text, then yes that should work

I suppose I asked for the wrong thing because it doesn't do what I need it to do.

I want it to sum up the total amounts paid in column "I".

As long as there is a date value in column H, then it should total up everything from column E as well as any amount from column F (providing that had a date value also from column G) but as long as it doesn't have a date value in column H on the same row. I don't know if that makes sense.


If any row doesn't have a date value in column G or H, then that shouldn't be included in the total.

Clear as mud, I know.

JH

Perhaps you need to look at SUMIF()?
test for date column to be > 0

Here's the logic...

I am due a commission amount (Column E).

But first, I am only paid half of that commission (column F) before being paid the last half at a later date (Column H).

So I want to keep a running total of how much I have received so far, whether I have been paid half or full.
Therefore, if there is a date of when I received payment, I want that to be included in the running total.

If there is no date, then that should not be included.

It's possible that a row may not have a date yet because a later commission was paid before an earlier one.

If I have received full payment, then there's no need to count the first half payment anymore for that row.

Does that make it any clearer?

JH