-
ISSUES WITH SUMIF WITH DATE CRITERIA
I have a sheet wherein the data is getting populated by way of form. I am trying to create sheet summary which tells me the qty input done in last 30 days and instances for last 30 days using Sumif and Cuntif formula. I get wrong answers. Need help to determine if my formula is right =SUMIF([DATE OF CONCRETE]:[DATE OF…
-
Index to equal exact matches
I created a formula that should look for a specific cell within a range from another sheet, and report back another column. However, it does not search an exact match. Formula: =INDEX({Res Sales Metrics Month}, MATCH([Date2]@row, {Res Sales Metrics Year-Month}), 0) I want my month name column to report back the actual…
-
Countifs using a Or Function
Can someone please tell me what the formula for the following criteria would be please: =Countifs(OR(Range1:Range1,@cell,Range2:range2,@cell),Range3:range3,@cell) Countifs If Range 1 or 2 has a value of @cell, then count the occurances Any help would be very helpful. Many thanks Mike
-
Attempting a formula with multiple criteria
Hi, I've 2 columns named "Audit Completed by" which contains a result from a contact list and "Audit Result" which gives dropdown result of pass or fail. Trying to give a sum of when both have a specific username and pass as below but keep getting #UNPARSEABLE result. =COUNTIFS([Audit Completed by]:[Audit Completed by],…
-
Countifs with Contains
Hi All, Need to add a contains element in to criteria 1 of my countifs formula: =COUNTIFS({POSG Pack Range 1}, Contains([Primary Column]3,1) {POSG Pack Range 2}, 1) Can anyone help me progress this? Many thanks, Mike
-
How to count items in a multi dropdown list?
Hello - I've read through plenty of scenarios on this topic but still haven't been able to get this to work exactly - I would like to write a formula that counts the number of functions within the dependency column as a whole. Currently, I am using a COUNTIF function for each individual function but it does not work when…
-
SUMIFS with two criteria
I am trying to SUM up the invoices were the Status is Match by Month and report on another file. I am having trouble with the formula. =SUMIFS({InvoicebyMonth}, [Invoice Visibility]3, {InvoiceAmt}, {MatchedStatus},"Matched”) To get the count of invoices I ended up putting in a column to show the number of invoices…
-
Getting a sheet to refresh data
I have a number of sheets that are fed data via forms. The sheets are setup to deal with this incoming data automatically and they feed selected information to Dashboards via reports and formulas that run within the sheets. The problem I have is that since there is no need to access these sheets, the data is not getting…
-
Auto-number function- broken
So I had functionality, where every time a new record was added (via a MS form) an project ID would be generated. The format is "IR- 0000" where the IR- was constant and the 0000 was a sequence #. (I would want it to start at seq # 0046) I cannot remember if I had used the auto-number column type or a formula. I am the…
-
Notification not sent to sheet owner
I have setup a notification that successfully sends an email to anyone that has been assigned to a task. However, if I assign a task to myself, I don't receive an email. Is this not receiving an email if you create the task or own the sheet normal? Mostly I was looking for the email to confirm I configuring the automation…