Google Sheets, conditional function for importing data between sheets on same file

[Drexo]

Hi, I’m using Google Sheets as my spread sheet software of choice on my iPad Pro and I’ve been trying really hard this thing about “going iPad Pro solo” for some time.

So far the learning curve is kind of steep but I’m slowly climbing it. It’s totally worth it for the portability but I’m stuck with one thing.

Basically I’m trying to do sums inside a file by importing data from a sheet and summing it up in another sheet inside the same file. The purpose of this is to have a clean database on one sheet (let’s say “sheet A”) with all expenses done in a month and on another sheet (“sheet B”) to do just analysis.

What I usually do on my PC is:

• On sheet B, in the desired cell I type “=SUM(“
• ...then manually, switching to sheet A, with the mouse pointer I go and click on the cell or cell blocks of data I need and the formula autofills.

The thing is in the iPadOS UI it’s not possible because the whole bottom bar where the sheets are all alligned disappears every time I type, even if I use a bluetooth keyboard case (Logitech Slim Folio Pro) so I can’t click physically to switch from sheet to sheet. I know, it’s some stupid limitations they came up with and they’re slowly testing my patience.

 

What I’m trying to do is to bypass the whole thing by trying a conditional formula. I know they work the same in Excel, I’ve seen them use by colleagues but I never did it myself.

 

I’ll try to explain my needs as clearly as possible if there’s anyone who can suggest me the correct formula composition.

In sheet A, the expenses list, each expense have a tag field, “STATUS”, that can be either “PENDING” or “PAID”.

I need the formula to add up in a desired cell on sheet B all expenses from sheet A that have the “PENDING” status.

 

I could use a formula such as =SUM(Sheet A!J7;Sheet A!J11;...) in sheet B but it would take too long to type it for hundreds of values and I’d like to take the chance to automate the whole thing so it all just auto adds up just by changing the status tag.

 

Does anyone know how?

Thank you very much.

 

[LogicalDrm]

Use as much cell ranges and copy-paste as possible. This seems to be good reason why iPad can't yet replace PC. Not before Apple allows full mouse and keyboard support.