Can you guide me?

I know how to use vba and call functions as sumifs or vlookup coding.

But I can’t find examples in BASIC performing that idea.

Suppose I have numbers in A1:A10 and gender (M o F) in B1:B10.

I’m trying to obtain the result in H3 doing: sumifs(a1:a10;H1;b1:b10;H2)

And H1 and H2 are the criteria for each range.

On VBA you can receive the result directly in H3 or write the formula in the cell.

Here in BASIC I’ve read some old posts saying that It is not possible doing that.

Am I right?

Thanks for your ideas and time, folks.

Have a nice day.