Brian W’s Profile

I cannot figure out why this formula doesn't work for me. I've tried a date instead of TODAY(), same results. Any help appreciated. Both columns are formatted for

I am looking for a simple formula to multiply [Quantity] times [Cost] only if there is data in the quantity cell. Currently the [total] column fills with $0.00 if there is no data in these columns. The "HELP" page is not clear to me on how to do the ISN'T Blank formula.

Thank you

Al

I've got 4 rows of data (and there will eventually be more). I'm trying to add up one column (Duration (in quarter hour increments)) IF another column (Program Bug) shows NO check in the checkbox field.

I put this formula together, but clearly I'm doing something wrong:

=if([Program Bug]4:[Program

Hi I've searched the community and can't seem to find an answer for this one.

I have a column with project roles and the hours for each role required for individual tasks.

I would like to summarize the total hours for each role

Currently I am creating hidden columns for each role and to determine

Hello all,

I'm looking to count the number of "stars" within a column and have been testing with

=COUNTIF(check_column, "true").  This isn't working.  Any

I want to create a cross-sheet formula and have two conditions for the formula to go through to result in a value. 

If the value in column1 is 1 and column2 is VendorX then sum all values in column3 corresponding to the conditions. 

I am not sure if the SUMIF will work for this.

Hello,


I'm trying to help build a sort of prioritization scorecard into a sheet. We have 4 columns, each with possible values of (example) "A", "B" or "C", and would like to have another column that sums each based on assigning a number value to each dropdown option.

So for example, the columns and

I have search and tried multiple expressions and cant seem to get things to work correctly.

I have columns:

Estimated Start Date

Actual Start Date

Estimated Completion

Current Finish Date

Actual Completion Date

What I would like is the RYG Ball to be blank for any row that does not contain an

I have a sheet that pulls some information from a master sheet using an INDEX/MATCH formula. Is there a way to make a copy of this sheet and retain the contents of the cells without the formulas?

Basically, I want to make an archive of the current state without it updating in the future to new

Please share with me your best advice.

I am sharing an inventory report. If the low level is greater than the actual # of units we have, I want the column to be highlighted. While reviewing conditional formatting I do not see how I can compare the two columns to create the formatting.

Each inventory