Hi,
A column with names like
Imran
Kamran
Shehzad
Imran
Shehzad
Kamran
Asif
Manan
Manan
Asif
B Column some numeric data.
I have a sum formula for B column.
Now If I filter the data for Imran. I want the sum formula to sum only for Imran. I can have a dropdown for names and use sumif but it will not show the entries for Imran,
"CAN WE HAVE A FORMULA (AND NOT VBA) TO GET SUM OF ONLY FILTERED RECORDS"
Bookmarks