Thanks. Is there a way to use it with the wild card feature?
I don't know offhand but it's worth a try!
Got it. You put the * where its pulling the criteria from. Also you don't need to put = before the criteria. (the ' gets put in automatically)
OhIt means that the column to sum is the 3rd column in the range (1st argument)
Is there a way to make it that if it says apple, green apple or red apple in the first column it won't count orange in the second column (in the same row)?
pretty sure it won't... since it's already counting that row due to the orange. It won't count it twice.
It counts it bec it's 2 different values.
in the same row? in my testing it doesn't. It's adding up all the values in C where the row meets criteria
It's counting it by me. There's 2 different criteria and each one is being met.
I am looking to show previous income.I have dates of service, inbsame sheet i have date paid.How do i pivot this information into a nice sheet.Eg. All dates in May, how long did it take to get paid All dates in June etc. Thanks
Ask chatgpt.
Thabks a million for that reminder. Tomorrow I will look