Forum Discussion
Dev_1518
Aug 17, 2022Copper Contributor
TO COUNT A CELL WITHOUTH USING COUNTIF
So i have an issue where i have been told to count the number of cell based on a certain criteria in this case i have to calculate the number of people working in sales dept i have two columns N...
OliverScheurich
Gold Contributor
Dev_1518
Aug 17, 2022Copper Contributor
Guess i didnt make myself clear i have to use an IF function . so is it possible to use the sumproduct inside the IF function??