Forum Discussion
To only use data from a column if the cell in a row contain the first 4 letters
Dear all, I am trying to sum data from a large data base containing calenderdays. I have one tab containing thses columns Date Hour Type 200831 0,5 Ordinary hours The tab contain 8779 rows an...
There is a discrepancy between your original description and your screenshots.
Try
=PRODUKTSUMMA((HELTAL(Data!A2:A10000/100)=O10)*Data!C2:C10000)
HansVogelaar
Wow that worked, half way 😉
It returned all "2001", but I wanted to return all "2001" with "Ordinary hours only" in column F of tab DATA (see pic DATA4.jpg).
Sorry for not being clear enough 🙂
In O11:
=PRODUKTSUMMA((HELTAL(Data!$A$2:$A$10000/100)=O$10)*(Data!$F$2:$F$10000=$N11);Data!$C$2:$C$10000)
Fill to the right and then down, or vice versa.
HansVogelaar
Hans, I am impressed, thank you soo very much ...
Greetings from Sweden