|
Counting ?
I have a spreadsheet with 3 columns - I want to know the number of times col
A = texta, and col b = textb and col c = text c. how do I do this in excel? |
Counting ?
=SUMPRODUCT((A1:A100="texta")*(B1:B100="textb")*(c 1:c100="textc"))
-- Gary''s Student - gsnu200908 |
| All times are GMT +1. The time now is 10:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com