Forum Discussion
Afranks335
Jun 01, 2021Copper Contributor
Counting 2 cells that meet 2 specific criteria
Hey all, extremely new to this and looking for some insight. I'm working on a spreadsheet to tally specific tasks done by specific people, but I have a feeling it's going to end up being a pretty...
Riny_van_Eekelen
Jun 01, 2021Platinum Contributor
Afranks335 Sounds like you could use a pivot table for this, providing that the two columns (A and L) are part of a larger data set, without empty columns between them. Alternatively, you can use COUNTIFS. Attached a file containing both.