Excelent explanation. A lot of different examples. I always wanted to know how to search for a specific word within a cell like the "*Fisher*" example, and I finally have found it. THANKS A LOT!!!
Quick question if you can help ?? How would you multiply same cell value with two different number ?? (1) For example value of the cell is 130 I want to multiply 100 with 5 and 30 with 2 . (2) I got another cell which value is 98 . I know I can simply multiply that with 5 . But I want the same formula which can work for both
Does anyone know how to use the CountifA from a completely separate google sheet? Not tab - that I know how to do. But a completely different sheet (google file).
In one cell of I've the following ["123-A-11", "123-A-1", "123-A-15", "123-A-21", "123-1"] Wanna find the count of "123- only, viz it's 5 What's the command?
Quite brilliant i love the way you explain the pre explanation , the sheet explanation and after explanation
Excelent explanation. A lot of different examples. I always wanted to know how to search for a specific word within a cell like the "*Fisher*" example, and I finally have found it. THANKS A LOT!!!
Rocked 🎉
Thanks!
Thank you! This was very helpful!
love this!
Thanks for sharing. Nice visuals. Keep it up
Tq so much, very clear explanation......
HOW CAN WE MAKE THE AUTOMATIC CHANGE OF ALL FORMULA ON THE RIGHT IF I LOOK AT THE STATE OF TEXAS IN COLUMN B?
ِشكرا
شكرا
شكرا
can sum each row with arrayformula? or any idea?
example data:
data result
1 1
2 3
3 6
dst dst
Quick question if you can help ??
How would you multiply same cell value with two different number ??
(1) For example value of the cell is 130
I want to multiply 100 with 5 and 30 with 2 .
(2) I got another cell which value is 98 . I know I can simply multiply that with 5 .
But I want the same formula which can work for both
Does anyone know how to use the CountifA from a completely separate google sheet? Not tab - that I know how to do. But a completely different sheet (google file).
How to count everything including text, numbers, blanks
In one cell of I've the following
["123-A-11", "123-A-1", "123-A-15", "123-A-21", "123-1"]
Wanna find the count of "123- only, viz it's 5
What's the command?
doesn't work that way at all this is useless!