Excel Worksheet Functions - Page 9

Thread / Thread Starter	Last Post	Replies	Views
SUMIF between date range rhhince[_2_]	by Wilbur Chua	1	694
Sum only negative numbers in the Sum Range of the SUMIF function Keyrookie	by Wilbur Chua	1	1,203
COUNTIF across multiple tabs in Google Sheets Victoria Emory	by Wilbur Chua	3	1,628
Using Forecast Dynamically David Cuthill[_3_]	by David Cuthill[_3_]	1	389
How to automatic cell lock after data entry iew ho	by Auric__	1	426
Formula doesn't work unless hit enter again Bobby	by AST ATY	7	4,252
splitting cells diagonally and filling with color yooper	by Nils Ejlertsson	5	3,918
Difference in value of a cell in Excel at two different time. PaddyStan	by Auric__	2	394
IF statement: how do I simply return the calculation in theconditional as one of the outcomes? David Terranova	by MyVeryOwnSelf[_3_]	1	756
How hide all Columns based on specific cell data Dilip Ghosh	by Auric__	1	623
Changing Numbering into Arabic!!!! Kareem Hamed	by Kareem Hamed	0	349
Match value in column number received from previous match HÃ¥kan BjÃ¶rkstrÃ¶m	by MyVeryOwnSelf[_3_]	3	495
Sum Data with Multiple Range = Multiple Range Ping_TH_Thamanart Tantisirivit	by Ping_TH_Thamanart Tantisirivit	1	369
Finding the position of the nth item in a list [email protected]	by JOSEP OLIVA	7	979
How do I get a sum from one cell with multiple numbers into another cell Chauncey Gearhart	by Thibaud Taudin Chabot	1	422
formula to switch last/first name around? Stilla	by Auric__	11	6,204
Complex Sumproduct formula Ray Smart	by Claus Busch	3	434
Round date to next half year Mark Sullivan	by Mark Sullivan	2	385
Lambda, Recursion, and Prime Factors ExcelBen	by ExcelBen	2	775
Eulier Totient Function David	by ExcelBen	9	7,020
How to filter Unique values from Duplicates San[_4_]	by Tim Paine	7	1,399
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN FRANK	by Tim Paine	7	6,506
Copy Pivot column from one Sheet to Another [email protected]	by Tim Paine	3	1,358
Linear weighted regression [email protected]	by Auric__	3	1,136
How to unhide column? Lois Corp Secy	by Tim Paine	5	1,637
How can i calculate the first sunday of each month [email protected]	by Tim Paine	1	963
How to make dependent drop down Lists San[_4_]	by Tim Paine	4	798
how do I delete data in a cell without deleting formula? tripy	by Tim Paine	9	5,251
Get biggest value, then the smaller one Xxer Xxes	by Xxer Xxes	2	385
count closest empty cells in a row Xxer Xxes	by Xxer Xxes	4	1,067
Calculate a sentences width based on lookup Phil Delaney	by jerry_maguire	1	507
Show value of first non contiguous data Xxer Xxes	by Xxer Xxes	11	1,239
Using IF Function to Recognize Highlighted Cell Blythe Richardson Smith	by Enrique Rivera	1	752
Last date edited - in a single cell to be updated every time a sheetis edited. meleady420	by Auric__	5	705
Adding 2 digits of a number together Gabriel C ZX	by MyVeryOwnSelf[_3_]	2	825
merge cells disabled how do I enable Gary	by Bernard Etienne Fety	7	4,972
google sheets truncate #characters but full words Phil Delaney	by Phil Delaney	2	580
Excel Error "That function is not valid" Patrick Henry Ewoi	by Patrick Henry Ewoi	0	797
How can we increment 1.9+0.1 and display 1.10 NOT 2.0 using formula ymadi	by Thibaud Taudin Chabot	6	4,289
Sum formula not working SAM HO	by Auric__	1	461
How to write a formula to get the maximum Amount of different TEAM directly wk3913	by MyVeryOwnSelf[_3_]	1	516
creating Multiple If Statements depending on specific cell entry [email protected]	by [email protected]	0	525
Dynamic SUMPRODUCT Jan Kronsell[_6_]	by Jan Kronsell[_6_]	2	733
HOW TO SUM EVERY OTHER COLUMN monir alizadeh	by MyVeryOwnSelf[_3_]	2	538
need to input alternate blank rows in spreadsheet Confused from Hertford	by [email protected]	7	1,504
eliminate negative value from normal random number distribution Ahmad	by abdelkader bouchami	5	994
Finding cells based on the colour of the text Jacob Cooke-TIlley	by Auric__	1	590
"Function Not Valid" - Getting Rid of the "@" symbol [email protected]	by Auric__	1	580
Random generation of employee assignments Blue Max	by Auric__	6	1,443
Randomly Assign Tasks to employees in a month without repetitions Mukayi Mutsago	by Mukayi Mutsago	0	605
UserForm code help Keyrookie	by Keyrookie	0	515
Auto lock the cells in Google sheet [email protected]	by [email protected]	0	1,063
conditional formatting [email protected]	by MyVeryOwnSelf[_3_]	1	457
calendar set up for corona virus ECQ -google drive spread sheet [email protected]	by [email protected]	0	499
Extraction of Part Numbers from Text Strings tb	by Claus Busch	8	509
Convert room dimensions 13' 8" X 9' 2" to square feet [email protected]	by [email protected]	6	1,717
Filter with Cell background color Keyrookie	by Keyrookie	0	876
Calculate holiday rate across holiday seasons Evets Snomis	by Evets Snomis	2	565
Annual leave - list days off [email protected]	by Evets Snomis	7	1,458
Arabic numbers [email protected]	by [email protected]	0	453
How do I round Up to the nearest hundred? [email protected]	by [email protected]	1	555
WORK HOURS DIFFERENCE BETWEEN TWO DATES CHRISTI	by [email protected]	14	5,299
How to find a date in the future Daddy Sage	by Claus Busch	1	637
Works perfect in excel how to apply in ghseet the same formula [email protected]	by [email protected]	0	373
Multiplying columsn and addin the results Daddy Sage	by Daddy Sage	2	456
Trying to replace vlookup with xlookup and not using the indirect function George[_35_]	by Harlan Grove[_2_]	3	1,461
Formula to pull first word from text string in a column CrisT	by [email protected]	15	3,027
Counting with two criterias Daddy Sage	by Lepista	6	866
Easter day formula. David2me	by David2me	0	651
Need a Static Timestamp Formula [email protected]	by [email protected]	3	2,013
Determine if a month falls between two dates - multiple years Silenteternity	by Silenteternity	0	650
Conditional Formatting Ignore 0 [email protected]	by [email protected]	0	634
automatically putting in dates like tuesday/thursday [email protected]	by [email protected]	0	408
An easier way to count equal values in two columns? Emilio Guerra	by Emilio Guerra	4	597
INDIRECT.EXT function, PULL function [email protected]	by [email protected]	0	582