Posts by Raluca

Hi all,

I am trying to create a dashboard on one page, but to include more info I need some chart and a pivot table to appear only on mouse hover, not sure if it is possible for the pivot to be captured on mouse hover. I attached an example file. When I hover over Orders Won label I want the Pivot on the right Column T:V to appear and when I hover over Lost Projects label the Chart on the right to appear. I didn't find anything with Pivot pop up not sure if it is possible, with the Chart I found something with linked image but I cannot paste that in my Excel 365 version, not sure if it is because it is a Pivot Chart.

If you could please have a look, looking forward for some guidance

Thank you

Thank you so much, I was trying the other way around nesting the SUM(CountIf) in the Sumifs, no wonder it didn't work

Hi all,

I am trying to sum the items in Column C that corresponds only to Status (column A) "Firm Quote" and "Requote" and Sub Status (column B) "In Progress", the result should be 4000.

Thank you!

Thank you so much!

forum.ozgrid.com/index.php?attachment/1232331/Hi,

I need to count how many calls are made each day based on that date occurrence in a cell with comments.

Is there a formula I could add in column E to show the results that I manually pasted please?

Or is there a way to count how many comments there are on a particular date?

Thank you!