Sign in to join the conversation:
Example
Column 1
banana
orange
watermelon
Column 2
kid 1
kid 2
kid 3
I want to create an equation that counts, how many times kid 1 has chosen banana and orange???
You would use something along the lines of...
=COUNTIFS([Column 2]:[Column 2], "kid 1", [Column 1]:[Column 1], AND(CONTAINS("banana", @cell), CONTAINS("orange", @cell)))
I have a sheet where it have some formulas which works on present date. Because of using today function in the formulas, the formulas are not getting updated until I open the sheet and click save.
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
